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
209 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
169 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
135 reads
Blogs
SQL Server on Kubernetes Book Published!
I’m super proud to announce that Ben E. Weissman and I have published SQL...
Gathering More Digital Data with Tile Slim
By Steve Jones
After my wallet misadventures, I ordered a Tile Slim to track my wallet. It...
Accessibility is not just about slides
Although I don’t write about it much on this website, I am on the...
Forums
Enabling indexes
If I disable an index for a large insert/update/delete, what happens when it's enabled...
Ask SSC