<a href="http://g.adspeed.net/ad.php?do=clk&zid=15220&wd=468&ht=60&pair=as" target="_top"><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
Search:
Home
Articles
Editorials
Forums
Scripts
Blogs
QotD
SQL Jobs
Training
Authors
About us
Contact us
Newsletters
Advertise
Write for us
Scripts with tags
T-SQL Aids
,
Miscellaneous
Refine your search with one of the following additional tags (with number of items):
Maintenance and Management
(163)
Data Warehouse
(24)
Mail
(7)
SQL Server 2000
(1)
SQLInsider Scripts
(104)
Index Management
(20)
Replication
(7)
SQL Server 2005
(1)
Backup / Restore
(25)
Lock and Connection Management
(11)
Full-Text Search (2005)
(1)
T-SQL
(1)
Search for
any
content tagged
T-SQL Aids & Miscellaneous
Add a script
Items 1 to 20 of 385
Next 20 >>
Proc to Rename a file
A simple way to rename a file from within a T-SQL Script, primarily designed to add a date-time stamp. Works in 2000 and 2005.
Read more...
By
Simon Facer
2008/06/17
|
Source:
SQLServerCentral.com
|
Category:
Miscellaneous
Rating:
|
Discuss
|
Briefcase
|
15 reads
Effectively mapping primary key – foreign key relations
This script maps the primary key - foreign key relations regardless if the column names are the same or not.
Read more...
By
John Liu
2008/01/10
|
Source:
SQLServerCentral.com
|
Category:
Miscellaneous
Rating:
|
Discuss
|
Briefcase
|
830 reads
Combine multiple rows into single output
Read more...
By
Mohit Nayyar
|
Category:
Miscellaneous
Rating:
|
Discuss
|
Briefcase
|
908 reads
LSTR() and RSTR(): Enhanced LEFT() and RIGHT()
Read more...
By
R. van Laake
|
Category:
Miscellaneous
Rating:
|
Discuss
|
Briefcase
|
145 reads
This SP will be create C# classes using all table
Read more...
By
Satya B
2007/11/13
|
Category:
Miscellaneous
Rating:
|
Discuss
|
Briefcase
|
1,447 reads
Get all user def table info with rowcount and size
Read more...
By
Mohit Nayyar
2007/11/19
|
Category:
Miscellaneous
Rating:
|
Discuss
|
Briefcase
|
3,195 reads
Display disk space stats for each table
Read more...
By
Andrew Greenall
|
Category:
Miscellaneous
Rating:
(not yet rated)
|
Discuss
|
Briefcase
|
274 reads
Get Record Count for each table in a database.
Read more...
By
~~Hari.Bagra
|
Category:
Miscellaneous
Rating:
|
Discuss
|
Briefcase
|
131 reads
Table row count using 3 different ways
Read more...
By
Mohit Nayyar
0001/01/01
|
Category:
Miscellaneous
Rating:
|
Discuss
|
Briefcase
|
1,046 reads
Locate primary key - foreign key relations
Read more...
By
Mohit Nayyar
0001/01/01
|
Category:
Miscellaneous
Rating:
|
Discuss
|
Briefcase
|
1,456 reads
Create Log tables and Triggers
Read more...
By
Srinivasulu Nasam
2007/10/26
|
Category:
Miscellaneous
Rating:
|
Discuss
|
Briefcase
|
1,520 reads
Function to Split Multivalued Parameter
Read more...
By
~~Hari.Bagra
2007/10/11
|
Category:
Miscellaneous
Rating:
|
Discuss
|
Briefcase
|
907 reads
Row count of all tables
Read more...
By
Girish Patil
|
Category:
Miscellaneous
Rating:
|
Discuss
|
Briefcase
|
367 reads
Find Column Name Usage
Read more...
By
kgayda
0001/01/01
|
Category:
Miscellaneous
Rating:
|
Discuss
|
Briefcase
|
2,933 reads
Find Column Usage
Read more...
By
kgayda
2007/10/10
|
Category:
Miscellaneous
Rating:
|
Discuss
|
Briefcase
|
3,281 reads
Display results VERTICALLY in Results window
Read more...
By
D Simmons
2007/05/21
|
Category:
Miscellaneous
Rating:
|
Discuss
|
Briefcase
|
242 reads
Get record count for every table in a database
Read more...
By
Wayne West
0001/01/01
|
Category:
Miscellaneous
Rating:
|
Discuss
|
Briefcase
|
746 reads
Function to Split a Delimited String into a Table
Read more...
By
Andy Brown
0001/01/01
|
Category:
Miscellaneous
Rating:
|
Discuss
|
Briefcase
|
1,144 reads
Set Proper Name Case Function
Read more...
By
K2mission
2007/04/24
|
Category:
Miscellaneous
Rating:
|
Discuss
|
Briefcase
|
119 reads
Send SMS from a trigger
Read more...
By
Al Siks
2007/04/16
|
Category:
Miscellaneous
Rating:
|
Discuss
|
Briefcase
|
5,223 reads
Items 1 to 20 of 385
Next 20 >>
Most popular
Find Column Usage
Read more...
By
kgayda
2007/10/10
|
Category:
Miscellaneous
Rating:
|
Discuss
|
Briefcase
|
3,281 reads
Send SMS from a trigger
Read more...
By
Al Siks
2007/04/16
|
Category:
Miscellaneous
Rating:
|
Discuss
|
Briefcase
|
5,223 reads
Get all user def table info with rowcount and size
Read more...
By
Mohit Nayyar
2007/11/19
|
Category:
Miscellaneous
Rating:
|
Discuss
|
Briefcase
|
3,195 reads
Copyright © 2002-2008 Simple Talk Publishing. All Rights Reserved.
Privacy Policy.
Terms of Use
