Log in
::
Register
::
Not logged in
Search:
Home
Articles
Editorials
Forums
Scripts
Blogs
QotD
SQL Jobs
Training
Authors
About us
Contact us
Newsletters
Advertise
Write for us
Scripts by Cade Bryant
SQLServerCentral.com profile
Items 1 to 20 of 27
Next 20 >>
Automatically generate SUID procs for any table
This proc generates SELECT, UPDATE, INSERT, and DELETE procs for any given table.
Read more...
By
Cade Bryant
2008/01/02
|
Source:
SQLServerCentral.com
|
Category:
Automation
Rating:
|
Discuss
|
Briefcase
|
776 reads
Generate C# class code for table
For any supplied table, my proc, usp_TableToClass, generates class code in C#, including fields, properties, getters and setters.
Read more...
By
Cade Bryant
2007/11/16
|
Source:
SQLServerCentral.com
|
Category:
Development
Rating:
|
Discuss
|
Briefcase
|
1,270 reads
Modified sp_who - more info & extra parameter
Read more...
By
Cade Bryant
|
Category:
Miscellaneous
Rating:
|
Discuss
|
Briefcase
|
368 reads
Parsing an IP address into its separate octets
Read more...
By
Cade Bryant
|
Category:
Miscellaneous
Rating:
|
Discuss
|
Briefcase
|
70 reads
Execute VBScript commands or .vbs files via T-SQL.
Read more...
By
Cade Bryant
|
Category:
Miscellaneous
Rating:
|
Discuss
|
Briefcase
|
326 reads
REVISED Dynamic Crosstab Query
Read more...
By
Cade Bryant
|
Category:
Miscellaneous
Rating:
|
Discuss
|
Briefcase
|
305 reads
Creating a Dynamic Crosstab Query
Read more...
By
Cade Bryant
|
Category:
Miscellaneous
Rating:
|
Discuss
|
Briefcase
|
503 reads
A faster way to count rows in a table
Read more...
By
Cade Bryant
|
Category:
Miscellaneous
Rating:
|
Discuss
|
Briefcase
|
128 reads
A more efficient ForEach routine
Read more...
By
Cade Bryant
|
Category:
Miscellaneous
Rating:
|
Discuss
|
Briefcase
|
260 reads
An alternative to self-joins
Read more...
By
Cade Bryant
|
Category:
Miscellaneous
Rating:
|
Discuss
|
Briefcase
|
133 reads
Search all objects in all DBs for code fragments
Read more...
By
Cade Bryant
|
Category:
Miscellaneous
Rating:
|
Discuss
|
Briefcase
|
130 reads
Improving performance on joins to large tables.
Read more...
By
Cade Bryant
|
Category:
Miscellaneous
Rating:
|
Discuss
|
Briefcase
|
427 reads
Show all User-Defined Datatypes for all Databases
Read more...
By
Cade Bryant
|
Category:
T-SQL Aids
Rating:
|
Discuss
|
Briefcase
|
64 reads
Dynamically Generating HTML Tags from T-SQL
Read more...
By
Cade Bryant
|
Category:
T-SQL Aids
Rating:
|
Discuss
|
Briefcase
|
91 reads
View Input Buffers for all SPIDS
Read more...
By
Cade Bryant
|
Category:
Miscellaneous
Rating:
|
Discuss
|
Briefcase
|
230 reads
"RESTORE..... WITH MOVE" all databases on a server
Read more...
By
Cade Bryant
|
Category:
Backup / Restore
Rating:
|
Discuss
|
Briefcase
|
382 reads
Correction to "drop/recreate objects" script.
Read more...
By
Cade Bryant
|
Category:
Lock and Connection Management
Rating:
|
Discuss
|
Briefcase
|
82 reads
Drop and re-create all stored procedures or views
Read more...
By
Cade Bryant
|
Category:
Lock and Connection Management
Rating:
|
Discuss
|
Briefcase
|
266 reads
The case against using single-line comments
Read more...
By
Cade Bryant
Rating:
|
Discuss
|
Briefcase
|
146 reads
SP for checking column uniqueness
Read more...
By
Cade Bryant
|
Category:
Index Management
Rating:
|
Discuss
|
Briefcase
|
330 reads
Items 1 to 20 of 27
Next 20 >>
Copyright © 2002-2008 Simple Talk Publishing. All Rights Reserved.
Privacy Policy.
Terms of Use