<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
<a href="http://g.adspeed.net/ad.php?do=clk&zid=15491&wd=120&ht=300&pair=as" target="_top"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15491&wd=120&ht=300&pair=as" alt="i" width="120" height="300"/></a>
Scripts with tag
t-sql
Search for
any
content tagged
t-sql
Add a script
<< Previous 20
Items 21 to 40 of 871
Next 20 >>
Print The Calendar 2
This script will print the calendar from the given date.
Read more...
By
Vinay Kumar
2012/08/10
|
Source:
SQLServerCentral.com
|
Category:
t-sql
Rating:
|
Discuss
|
Briefcase
|
1,537 reads
Calculate alphabetic sequence
This simple function allows to calculate a code sequence of letters. AAA, AAB, AAAC, ADF, .... AAZ, ABA, ABC, ... ZZZ
Read more...
By
Lobo Mau
2012/08/08
|
Source:
SQLServerCentral.com
|
Category:
sequence of letters
Rating:
|
Discuss
|
Briefcase
|
861 reads
Check Used Table Space for User Defined Tables
Query the System Tables to find the space usage, which helps Database Administrators identify the Tables that are using the most space.
Read more...
By
Tiger
2012/07/11
|
Source:
SQLServerCentral.com
|
Category:
storage management
Rating:
|
Discuss
|
Briefcase
|
1,121 reads
Delete old backup
Delete old backup files on a prespecified folder.
Read more...
By
Matimba Maluleke
2012/07/03
|
Source:
SQLServerCentral.com
|
Category:
t-sql
Rating:
|
Discuss
|
Briefcase
|
1,076 reads
Use your own optimizer to tune queries
Use your own optimizer to tune queries
Read more...
By
Gulli Meel
2012/06/07
|
Source:
SQLServerCentral.com
|
Category:
custome statistics
Rating:
|
Discuss
|
Briefcase
|
2,517 reads
Get a range of numbers
If you need to get a range sequence of numbers this script can help you to acomplish it. For example : the sequency of numbers between -5 and 5 or 1 and 200, etc..
Read more...
By
Bernabe Diaz
2012/10/05
|
Source:
SQLServerCentral.com
|
Category:
t-sql
Rating:
|
Discuss
|
Briefcase
|
1,072 reads
How to query dBase .dbf from SQL 2012 64-bit
Query dBase .dbf Files From SQL 2012 64-bit.
Read more...
By
James Ochsenfeld
2012/05/09
|
Source:
SQLServerCentral.com
|
Category:
t-sql
Rating:
|
Discuss
|
Briefcase
|
758 reads
Swiss Cheese!
Are you trying to determine the gaps in a numerical sequence?
Read more...
By
John Esraelo
2012/04/26
|
Source:
SQLServerCentral.com
|
Category:
sql script
Rating:
|
Discuss
|
Briefcase
|
879 reads
Did you say denormalize, why?
How to display data from 1-to-many in a single record!
Read more...
By
John Esraelo
2012/04/25
|
Source:
SQLServerCentral.com
|
Category:
t-sql
Rating:
|
Discuss
|
Briefcase
|
2,062 reads
Script to get database restore history
T-SQL to get restore history of SQL databases.
Read more...
By
Suleman Mohammed
2012/03/16
|
Source:
SQLServerCentral.com
|
Category:
t-sql
Rating:
|
Discuss
|
Briefcase
|
1,245 reads
Split Function to break the Job History Message into a Table
Split Function for T-SQL Server to break the Job History Message into Table.
Read more...
By
Ludwig Guevara
2012/03/22
|
Source:
SQLServerCentral.com
|
Category:
t-sql
Rating:
(not yet rated)
|
Discuss
|
Briefcase
|
962 reads
Select the last error in the job selected
The job will send an HTML email with the latest error at specific job.
Read more...
By
Ludwig Guevara
2012/03/15
|
Source:
SQLServerCentral.com
|
Category:
sql jobs
Rating:
(not yet rated)
|
Discuss
|
Briefcase
|
796 reads
TSQL fast unix timestamp conversion
How to convert Unix timestamp into datetime taking into account also summer or winter time
Read more...
By
Federico Iori
2011/12/02
|
Source:
SQLServerCentral.com
|
Category:
timestamp
Rating:
|
Discuss
|
Briefcase
|
418 reads
Compare 2 datasets and output delta in one TSQL statement
There are many ways 2 compare datasets to find differences, this is one of them.
Read more...
By
Theo Ekelmans
2011/11/04
|
Source:
SQLServerCentral.com
|
Category:
t-sql
Rating:
|
Discuss
|
Briefcase
|
1,968 reads
who can do what?
list each user has the right to do
Read more...
By
Ricardo Leka
2011/10/31
|
Source:
SQLServerCentral.com
|
Category:
security
|
SQL Scripts Manager Compatible
Rating:
|
Discuss
|
Briefcase
|
2,035 reads
Different ways to write Distinct Query - MSSQL
Distinct Query
Read more...
By
Krishna Mohan Thamisetty
2011/11/01
|
Source:
SQLServerCentral.com
|
Category:
t-sql
Rating:
|
Discuss
|
Briefcase
|
2,365 reads
search and replace a string in all user tables’ data in all databases
This script will search for the input string in all the tables(data) from all the databases and will generate a script that will replace the searched string with the required string passed
Read more...
By
Parag Bhuyar
2011/11/10
|
Source:
SQLServerCentral.com
|
Category:
t-sql
Rating:
|
Discuss
|
Briefcase
|
1,127 reads
Convert string Hex to Numeric with inline TSQL
A fast way to convert a string containing Hex values to numeric
Read more...
By
Federico Iori
2013/01/18
|
Source:
SQLServerCentral.com
|
Category:
hexadecimal conversion numeric inline fast
Rating:
|
Discuss
|
Briefcase
|
1,170 reads
Grouping Sets
This script is to check for Queries returning same result set.
Read more...
By
Vaidya VS
2011/10/12
|
Source:
SQLServerCentral.com
|
Category:
t-sql
Rating:
|
Discuss
|
Briefcase
|
770 reads
Copy One Schema to Another Schema
This script copies one object in another multiple schema.
Read more...
By
Vinay Kumar
2011/08/31
|
Source:
SQLServerCentral.com
|
Category:
t-sql
Rating:
|
Discuss
|
Briefcase
|
1,042 reads
<< Previous 20
Items 21 to 40 of 871
Next 20 >>
Copyright © 2002-2013 Simple Talk Publishing. All Rights Reserved.
Privacy Policy.
Terms of Use.
Report Abuse.
