<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,534 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
|
622 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
|
679 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
|
889 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,082 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,243 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,205 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,603 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,173 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,352 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,054 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,441 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,253 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
|
872 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,902 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
|
855 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,111 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,487 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.
