Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 


 

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,191 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 2012/09/06 | Source: SQLServerCentral.com | Category: development
Rating: |  Discuss |   Briefcase | 8,007 reads

Modified sp_who - more info & extra parameter

Read more...
By Cade Bryant 2013/05/22 | Category: miscellaneous
Rating: |  Discuss |   Briefcase | 602 reads

Parsing an IP address into its separate octets

Read more...
By Cade Bryant 2013/05/22 | Category: miscellaneous
Rating: |  Discuss |   Briefcase | 550 reads

Execute VBScript commands or .vbs files via T-SQL.

Read more...
By Cade Bryant 2013/05/22 | Category: miscellaneous
Rating: |  Discuss |   Briefcase | 3,988 reads

REVISED Dynamic Crosstab Query

Read more...
By Cade Bryant 2013/05/22 | Category: miscellaneous
Rating: |  Discuss |   Briefcase | 709 reads

Creating a Dynamic Crosstab Query

Read more...
By Cade Bryant 2013/05/22 | Category: miscellaneous
Rating: |  Discuss |   Briefcase | 2,512 reads

A faster way to count rows in a table

Read more...
By Cade Bryant 2013/05/22 | Category: miscellaneous
Rating: |  Discuss |   Briefcase | 357 reads

A more efficient ForEach routine

Read more...
By Cade Bryant 2013/05/22 | Category: miscellaneous
Rating: |  Discuss |   Briefcase | 2,145 reads

An alternative to self-joins

Read more...
By Cade Bryant 2013/05/22 | Category: miscellaneous
Rating: |  Discuss |   Briefcase | 389 reads

Search all objects in all DBs for code fragments

Read more...
By Cade Bryant 2013/05/22 | Category: miscellaneous
Rating: |  Discuss |   Briefcase | 230 reads

Improving performance on joins to large tables.

Read more...
By Cade Bryant 2013/05/22 | Category: miscellaneous
Rating: |  Discuss |   Briefcase | 1,321 reads

Show all User-Defined Datatypes for all Databases

Read more...
By Cade Bryant 2013/05/22 | Category: t-sql
Rating: |  Discuss |   Briefcase | 142 reads

Dynamically Generating HTML Tags from T-SQL

Read more...
By Cade Bryant 2013/05/22 | Category: t-sql
Rating: |  Discuss |   Briefcase | 618 reads

View Input Buffers for all SPIDS

Read more...
By Cade Bryant 2013/05/22 | Category: miscellaneous
Rating: |  Discuss |   Briefcase | 581 reads

"RESTORE..... WITH MOVE" all databases on a server

Read more...
By Cade Bryant 2013/05/22 | Category: backup / restore
Rating: |  Discuss |   Briefcase | 1,530 reads

Correction to "drop/recreate objects" script.

Read more...
By Cade Bryant 2013/05/22 | Category: lock and connection management
Rating: |  Discuss |   Briefcase | 178 reads

Drop and re-create all stored procedures or views

Read more...
By Cade Bryant 2013/05/22 | Category: lock and connection management
Rating: |  Discuss |   Briefcase | 1,013 reads

The case against using single-line comments

Read more...
By Cade Bryant 2013/05/22
Rating: |  Discuss |   Briefcase | 258 reads

SP for checking column uniqueness

Read more...
By Cade Bryant 2013/05/22 | Category: indexing
Rating: |  Discuss |   Briefcase | 437 reads
   Items 1 to 20 of 27    Next 20 >>
 
 
Copyright © 2002-2013 Simple Talk Publishing. All Rights Reserved. Privacy Policy. Terms of Use. Report Abuse.