Finding a particular column in All tables
The script can be used to find all the tables that have the particular column name in it.
2007-07-25 (first published: 2006-11-06)
122 reads
The script can be used to find all the tables that have the particular column name in it.
2007-07-25 (first published: 2006-11-06)
122 reads
I wrote this to calculate the median on a record set. All you need to pass is the table name and column name. If you would like to filter the record set, create a view that displays the correct record.The limitation of not being able to pass arrays to Stored procedure or functions was the […]
2007-02-23 (first published: 2006-10-30)
645 reads
In this video, Kathi continues her T-SQL series and exands how to use the WHERE clause.
2006-10-26
3,469 reads
2006-10-24
2,332 reads
In this second part video from Kathi, she covers how to write T-SQL in much more indepth. She covers how to handle NULLs and many more items in this video.
2006-10-12
2,787 reads
There are so many new features in SQL Server 2005 that there's one that can make a significant impact in solving many different types of problems. Andy Warren takes a look at one of the features that has been enhanced and is extremely useful, albeit quirky: TOP.
2006-10-05
18,906 reads
In this video, you'll learn how to write basic select statements. This beginner video takes you from the ground up writing T-SQL.
2006-10-04
3,402 reads
Tim Chapman discusses using table valued functions with the APPLY function.
2006-10-04
2,404 reads
It is a modified version of original script I found on net. This script creates conditional Update statements too.
2007-07-05 (first published: 2006-10-03)
505 reads
2006-09-27
1,841 reads
By Steve Jones
mottleheaded – adj. feeling uneasy when socializing with odd combinations of friend and family,...
By Rob Sewell
In the WordPress community, badges aren’t just for scouts.
By James Serra
The new data governance features in Microsoft Purview are now being made generally available...
Comments posted to this topic are about the item New article
Comments posted to this topic are about the item Monitoring Azure Blob Storage
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers