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
The T-SQL Tuesday Corollary
T-SQL Tuesday is a fantastic series of blog posts derived from over 130 topics...
How to Import Perfmon Data into a SQL Server for Analysis
By kleegeek
If you followed the last video, I showed you how to set up windows...
How To Set Up Perfmon for 24×7 Collection
By kleegeek
I just released a new training video (one of many to be released in...
Forums
OLAPQueryLog does not work for SSAS Tabular mode
I running into a problem when I try to setup querylog in SSAS. The...
MasOffer Affiliate m?t hình th?c ki?m ti?n v?i ti?p th? liên k?t
[/b] MasOffer là m?ng ti?p th? k?t liên r?t l?ng danh ? Vi?t Nam....
Code to auto-update tables on set date
I am in a project where information is being pulled from a database then...
Ask SSC