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
130 reads
Blogs
Quick Blog: Making the Power BI PowerShell cmdlets easier to use
By Aaron Nelson
One of the top reasons I love PowerShell so much is that from the...
Trouble writing? Join the club. #JustWriteTech
By Jen McCown
I was talking with a couple of excellent SQL people* recently, and we were bemoaning...
Check Query Progress with Live Query Stats
This is something I touched on back in 2017 a little after the Live...
Forums
Is Data the Future of the Vibrant Web?
Comments posted to this topic are about the item Is Data the Future of...
Need some advice as to how convert reports to use embedded data
I've been using SSRS, on and off, for about 10 years. I wouldn't call...
Index maintenance Ola script
Hi All, Does Ola Hallengren index script takes care of de-fragmenting HEAP tables as...
Ask SSC