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
208 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
168 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
134 reads
Blogs
Daily Coping 20 Apr 2021
By Steve Jones
I started to add a daily coping tip to the SQLServerCentral newsletter and to...
The Diverse Data Platform–Dativerse.io
By Steve Jones
The other day I got a note from Ben Weissman the other day that...
Extended Events and Azure SQL Database
Knowledge of how your system behaves is vital to better control, maintain, and grow...
Forums
usage of BCP and BULK INSERT
as I'm not clear how to use bcp and bulk insert in the following...
sequence of SQL server execution plan
As per my understanding, when we read the execution plan, the sql server is...
An Empty Integer Numpy Array
Comments posted to this topic are about the item An Empty Integer Numpy Array
Ask SSC