Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

Scripts with tag T-SQL Rss

Search for any content tagged t-sql

Get your favorite SSC scripts directly in SSMS with the free SQL Scripts addin. Search for scripts directly from SSMS, and instantly access any saved scripts in your SSC briefcase from the favorites tab.
Download now (direct download link)

Add a script

<< Newer    Items 21 to 40 of 887    Older >>
 

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 | 1,108 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 | 1,482 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,579 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,496 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,599 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 | 2,250 reads

Open transactions on a database

This script will show you all open transactions from any query windows.  Read more...
By kyle.eldridge 2013/08/29 | Source: SQLServerCentral.com | Category: transactions
Rating: |  Discuss |   Briefcase | 2,670 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,857 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,409 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: |  Discuss |   Briefcase | 943 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,621 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,866 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: |  Discuss |   Briefcase | 1,567 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 | 1,080 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 | 2,179 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: |  Discuss |   Briefcase | 2,033 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,708 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 | 928 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,194 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,267 reads
<< Newer    Items 21 to 40 of 887    Older >>