The script finds occurrences of string(s) in stored procedures, triggers and views. You can use typical boolean logic as described in the script comments. Very useful. It was found on the companion cd to [Gurus Guide to Transact-SQL] by Henderson. I left in the original credits. Excellent procedure. Some may scoff but I place it […]
2004-07-15 (first published: 2004-07-02)
604 reads
This script creates comma separated lists of columns in different formats. These lists can be copied and pasted into other T-SQL statements. The lists are formatted as: a simple list of column names, a list with the column names as declared variables (@ + column name + data type), a list with column names as […]
2002-12-26
198 reads
By Steve Jones
We’ve been doing some events as part of the Redgate Roadshow, and at one...
By James Serra
As I have mentioned in prior blog posts, I have been writing a data...
By alevyinroc
I’m happy to announce that I will be speaking at SQL Saturday Boston on...
Some of our databases are getting be close to 2 terabytes. We are backing...
I'm working on a data analysis project in Python and need to calculate both...
Hi, My .mdf file is accidentally deleted at client's place and without bothering the...
Ask SSC