Search for text in procedures (no cursors)
This function returns a list of all procedures and functions that contain the given text value. It has an additional parameter to exclude procedures that contain a second text value.
2004-04-08
207 reads
Func. generates insert and select for large table
Generates an insert statement including column list. Useful for identity table data copying. Just modify the code generated to select and insert the needed fields. Saves time on large table inserts (also generates a select statement. Use part or all of the SQL generated. Saves development time when dealing with large tables.
2003-02-21
166 reads
Gen. vars, types and select into vars for a table
Generates a declare statement including data types for a table and generates a select statement to set the variables from the table. Speeds development time when dealing with getting values into variable from large tables.
2003-02-21
132 reads
Blogs
T-SQL Tuesday #125 – Unit testing databases – we need to do this!!
By HamishWatson
Welcome to the first April edition of T-SQL Tuesday. I’m honoured to be hosting...
T-SQL Tuesday Live–7 Apr 2020
By Steve Jones
Last week went a little crazy, and I learned something: don’t post a Zoom...
Getting Your dbatools Version–#SQLNewBlogger
By Steve Jones
Another post for me that is simple and hopefully serves as an example for...
Forums
Dial sbcglobal helpline for Customer Service
SBCGlobal Email Settings: If you are going to use Sbcglobal for your email applications...
How not to have sql to restart on the same node but failover on 1st failure in a
Hi, By default sql tries to restart on the same node in case of...
Do I need to update statistics after compressing table?
I page-compressed a table with one Clustered and 4 non-clustered indexes, 5 million rows....
Ask SSC