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 41 to 60 of 894    Older >>
 

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,105 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,218 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,055 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,730 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 | 935 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,208 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,292 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,804 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,137 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 | 838 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 | 952 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,162 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,382 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 | 1,011 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 | 849 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 | 460 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 | 2,127 reads

who can do what?

list each user has the right to do  Read more...
Rating: |  Discuss |   Briefcase | 2,208 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,290 reads
<< Newer    Items 41 to 60 of 894    Older >>