<a href="http://g.adspeed.net/ad.php?do=clk&zid=15220&wd=468&ht=60&pair=as" target="_blank"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15220&wd=468&ht=60&pair=as" alt="i" width="468" height="60"/></a>
Log in
::
Register
::
Not logged in
Home
Tags
Articles
Editorials
Stairways
Forums
Scripts
Videos
Blogs
QotD
Books
Ask SSC
SQL Jobs
Training
Authors
About us
Contact us
Newsletters
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
|
1,165 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
0001/01/01
|
Source:
SQLServerCentral.com
|
Category:
development
Rating:
|
Discuss
|
Briefcase
|
6,796 reads
Modified sp_who - more info & extra parameter
Read more...
By
Cade Bryant
|
Category:
miscellaneous
Rating:
|
Discuss
|
Briefcase
|
589 reads
Parsing an IP address into its separate octets
Read more...
By
Cade Bryant
|
Category:
miscellaneous
Rating:
|
Discuss
|
Briefcase
|
510 reads
Execute VBScript commands or .vbs files via T-SQL.
Read more...
By
Cade Bryant
|
Category:
miscellaneous
Rating:
|
Discuss
|
Briefcase
|
3,871 reads
REVISED Dynamic Crosstab Query
Read more...
By
Cade Bryant
|
Category:
miscellaneous
Rating:
|
Discuss
|
Briefcase
|
686 reads
Creating a Dynamic Crosstab Query
Read more...
By
Cade Bryant
|
Category:
miscellaneous
Rating:
|
Discuss
|
Briefcase
|
2,406 reads
A faster way to count rows in a table
Read more...
By
Cade Bryant
|
Category:
miscellaneous
Rating:
|
Discuss
|
Briefcase
|
338 reads
A more efficient ForEach routine
Read more...
By
Cade Bryant
|
Category:
miscellaneous
Rating:
|
Discuss
|
Briefcase
|
2,092 reads
An alternative to self-joins
Read more...
By
Cade Bryant
|
Category:
miscellaneous
Rating:
|
Discuss
|
Briefcase
|
355 reads
Search all objects in all DBs for code fragments
Read more...
By
Cade Bryant
|
Category:
miscellaneous
Rating:
|
Discuss
|
Briefcase
|
226 reads
Improving performance on joins to large tables.
Read more...
By
Cade Bryant
|
Category:
miscellaneous
Rating:
|
Discuss
|
Briefcase
|
1,264 reads
Show all User-Defined Datatypes for all Databases
Read more...
By
Cade Bryant
|
Category:
t-sql aids
Rating:
|
Discuss
|
Briefcase
|
135 reads
Dynamically Generating HTML Tags from T-SQL
Read more...
By
Cade Bryant
|
Category:
t-sql aids
Rating:
|
Discuss
|
Briefcase
|
566 reads
View Input Buffers for all SPIDS
Read more...
By
Cade Bryant
|
Category:
miscellaneous
Rating:
|
Discuss
|
Briefcase
|
551 reads
"RESTORE..... WITH MOVE" all databases on a server
Read more...
By
Cade Bryant
|
Category:
backup / restore
Rating:
|
Discuss
|
Briefcase
|
1,300 reads
Correction to "drop/recreate objects" script.
Read more...
By
Cade Bryant
|
Category:
lock and connection management
Rating:
|
Discuss
|
Briefcase
|
169 reads
Drop and re-create all stored procedures or views
Read more...
By
Cade Bryant
|
Category:
lock and connection management
Rating:
|
Discuss
|
Briefcase
|
964 reads
The case against using single-line comments
Read more...
By
Cade Bryant
Rating:
|
Discuss
|
Briefcase
|
253 reads
SP for checking column uniqueness
Read more...
By
Cade Bryant
|
Category:
indexing
Rating:
|
Discuss
|
Briefcase
|
433 reads
Items 1 to 20 of 27
Next 20 >>
Copyright © 2002-2012 Simple Talk Publishing. All Rights Reserved.
Privacy Policy.
Terms of Use.
Report Abuse.
