SQLServerCentral: Scripts tagged T-SQL

Click here to monitor SSC

<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>

SQLServerCentral is supported by Red Gate Software Ltd.

Log in :: Register :: Not logged in

<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 871 Next 20 >>

Finding queries to tune

A query to help identify queries that need some tuning. Read more...

By Simon Osborne 2013/06/11 | Source: SQLServerCentral.com | Category: t-sql

Rating:

|

Briefcase | 1,498 reads

Search all stored procedures on all databases

Need to find every stored procedure in any database that references the table FooBar? Here is a quick and easy search to do that. Read more...

By Jim Youmans 2013/05/30 | Source: SQLServerCentral.com | Category: t-sql

Rating:

|

Briefcase | 1,056 reads

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:

|

Briefcase | 1,871 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:

|

Briefcase | 695 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:

|

Briefcase | 752 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:

|

Briefcase | 989 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:

|

Briefcase | 1,182 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:

|

Briefcase | 1,285 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:

|

Briefcase | 1,267 reads

Get Database Size

Know you database size Read more...

By Vinay Kumar 2013/02/18 | Source: SQLServerCentral.com | Category: t-sql

Rating:

|

Briefcase | 1,709 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:

|

Briefcase | 1,234 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:

|

Briefcase | 1,418 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:

|

Briefcase | 1,102 reads

Manipulate Horizontal Hierarchy with UNPIVOT

Convert Horizontal Hierarchy to vertical Hierarchy. Read more...

By Bernabe Diaz 2012/12/20 | Source: SQLServerCentral.com | Category: t-sql

Rating: (not yet rated) |

Briefcase | 746 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:

|

Briefcase | 1,465 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:

|

Briefcase | 2,324 reads

Scripting CREATE INDEX Statements Automatically From Your Tables

Stored proc for scripting out full CREATE INDEX statements from your table indexes with all filegroup, filter and WITH parameters. Read more...

By Derek Colley 2012/11/27 | Source: SQLServerCentral.com | Category: indexing

Rating:

|

Briefcase | 1,277 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:

|

Briefcase | 896 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:

|

Briefcase | 1,922 reads

Script to get an ordered list of all stored procedures with parameters

Generate a per-schema, per-procedure ordered list of all stored procedures for the current database, together with their parameters, datatypes and nullability. Read more...

By Derek Colley 2012/08/14 | Source: SQLServerCentral.com | Category: t-sql

Rating:

|

Briefcase | 1,885 reads

Items 1 to 20 of 871 Next 20 >>