<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
Items 1 to 20 of 864
Next 20 >>
Run SQL code on each database
You can use this to run a script/s on multiple databases
Read more...
By
Ashley McLellan
2013/04/10
|
Source:
SQLServerCentral.com
|
Category:
t-sql
Rating:
|
Discuss
|
Briefcase
|
1,563 reads
Backup all SSAS databases using TSQL
Enumerates and backups all SSAS DB's
Read more...
By
Theo Ekelmans
2013/03/28
|
Source:
SQLServerCentral.com
|
Category:
automatic
Rating:
|
Discuss
|
Briefcase
|
624 reads
Copy Sql Objects
Copy tables, procedures, functions and view from one schema and another schema.
Read more...
By
Vinay Kumar
2013/03/29
|
Source:
SQLServerCentral.com
|
Category:
t-sql
Rating:
|
Discuss
|
Briefcase
|
684 reads
Copy Table
Copy tables from one schema to another schema.
Read more...
By
Vinay Kumar
2013/04/03
|
Source:
SQLServerCentral.com
|
Category:
t-sql
Rating:
|
Discuss
|
Briefcase
|
895 reads
Create Table with T-SQL
Generate create table statement using T-SQL.
Read more...
By
Vinay Kumar
2013/04/01
|
Source:
SQLServerCentral.com
|
Category:
t-sql
Rating:
|
Discuss
|
Briefcase
|
1,091 reads
Converting to datetime a char field with several possible date formats
Converting to datetime a char field having several possible date formats
Read more...
By
Federico Iori
2013/02/21
|
Source:
SQLServerCentral.com
|
Category:
t-sql
Rating:
|
Discuss
|
Briefcase
|
1,245 reads
Transpose Query Output
script to return query result transposed.
Read more...
By
Florian Cechi
2013/02/22
|
Source:
SQLServerCentral.com
|
Category:
t-sql
Rating:
|
Discuss
|
Briefcase
|
1,207 reads
Get Database Size
Know you database size
Read more...
By
Vinay Kumar
2013/02/18
|
Source:
SQLServerCentral.com
|
Category:
t-sql
Rating:
|
Discuss
|
Briefcase
|
1,611 reads
Open transactions on a database
This script will show you all open transactions from any query windows.
Read more...
By
kyle.eldridge
2013/01/30
|
Source:
SQLServerCentral.com
|
Category:
transactions
Rating:
|
Discuss
|
Briefcase
|
1,177 reads
T-SQL Bulk Insert
T-SQL that allows you to import tab delimited text file into correct table based on file name.
Read more...
By
Ervin Santiago
2013/02/07
|
Source:
SQLServerCentral.com
|
Category:
t-sql
Rating:
|
Discuss
|
Briefcase
|
1,357 reads
Number of Working Days
Number of workings days in a month minus weekends and holidays.
Read more...
By
Ervin Santiago
2013/02/08
|
Source:
SQLServerCentral.com
|
Category:
workdays
Rating:
|
Discuss
|
Briefcase
|
1,059 reads
Print Text Month Calendar
This function return the text format of a month calendar. It could be useful for sending through emails when you do do not have other tools, but T-SQL to send text emails.
Read more...
By
Bernabe Diaz
2012/11/29
|
Source:
SQLServerCentral.com
|
Category:
t-sql
Rating:
|
Discuss
|
Briefcase
|
1,442 reads
Deleting Duplicate Records
In Datawarehousing, a normal scenario is eleminating duplicate records/rows or deleting duplicate records, here's the solution.
Read more...
By
Shankar Walvekar
2012/11/20
|
Source:
SQLServerCentral.com
|
Category:
t-sql
Rating:
|
Discuss
|
Briefcase
|
2,259 reads
SCD Implementation with TSQL
ETL for a SCD using only TSQL, without hash functions
Read more...
By
Federico Iori
2012/11/13
|
Source:
SQLServerCentral.com
|
Category:
scd
Rating:
|
Discuss
|
Briefcase
|
873 reads
Create A Folder With T-SQL
Pass a folder name to this SP and it will create the folder for you.
Read more...
By
Howard Dunn
2012/10/16
|
Source:
SQLServerCentral.com
|
Category:
create a folder
Rating:
|
Discuss
|
Briefcase
|
1,908 reads
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,525 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
|
857 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,112 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,488 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,069 reads
Items 1 to 20 of 864
Next 20 >>
Copyright © 2002-2013 Simple Talk Publishing. All Rights Reserved.
Privacy Policy.
Terms of Use.
Report Abuse.
