usp_addcolumns
This is a stored procedure to add a columns to multiple tables, if column doesn't exist
2013-07-09 (first published: 2008-05-27)
953 reads
T-SQL
2008-05-27
5,148 reads
Finding Available Keys When Merging Two Tables
Find available keys when merging two tables with duplicate keys.
2008-05-26
4,539 reads
Passing Parameters as (almost) 1, 2, and 3 Dimensional Arrays
It's a well known fact that there's no such thing as a true "array" in SQL Server and that you can't pass a table as a parameter... but you can get a lot closer than you think.
2010-01-08 (first published: 2008-05-22)
33,849 reads
2008-05-19
4,650 reads
2008-05-14
4,968 reads
2008-05-13
6,057 reads
2008-05-07
4,907 reads
The "Numbers" or "Tally" Table: What it is and how it replaces a loop
Many people have used a "Numbers" or "Tally" table without really knowing what it does. This is an introduction as to how a Tally table replaces a loop.
2022-09-05 (first published: 2008-05-07)
153,765 reads
2008-05-06
4,178 reads
Blogs
Have a Plan for Your Personal Downtime
By Brian Kelley
Most of us know that spending a lot of time on social media and...
Monday Monitor Tips: Lots of Postgres Options
By Steve Jones
Redgate Monitor is growing to include more than just Microsoft SQL Server monitoring. We...
Advice I Like: Experience and Aptitude
By Steve Jones
Experience is overrated. Most breakthrough accomplishments were done by people doing them for the...
Forums
Issues with SQL Server 2022 Server
Hello, At my work place I recently migrated our test environment to SQL Server...
Remote query is taking 99% cost of local sp execution
So we have local sp in which remote table is udpated.this remote query part...
Question of the Day
Data API Builder APIs
What formats of API endpoints can the Data API Builder present to clients when exposing the database?
See possible answers