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
SQL Clone Works with FILESTREAM
By Steve Jones
SQL Clone is an amazing product that virtualizes your data, allowing multiple instances to...
Fun and profit with UTF-8
When SQL Server 2019 was announced, it brought with it UTF-8 support. Also available...
Data Platform MVP 2020
I am humbled to be among so many great professionals and honored at the...
Forums
Removing TDE from a Database: Level 4 Stairway to TDE
Comments posted to this topic are about the item Removing TDE from a Database:...
Database Modeling - Relationships
Comments posted to this topic are about the item Database Modeling - Relationships, which...
Read database objects relationship in easy steps
Comments posted to this topic are about the item Read database objects relationship in...
Ask SSC