SQL Server Central is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
Search:  
 
Home Articles Editorials Forums Scripts Blogs QotD SQL Jobs Training Authors About us Contact us Newsletters Advertise Write for us
 

Scripts with tag T-SQL Rss

Refine your search with one of the following additional tags (with number of items):

SQL Server 2005 (4)     Miscellaneous (2)     Puzzle (1)     Table (1)    
String Manipulation (4)     Development (1)     Referential Integrity (1)     Table-valued function (1)    
Automation (3)     Encode (1)     scalar-valued function (1)     Tools (1)    
Maintenance (3)     ETL (1)     Script Generator (1)     TSQL (1)    
Administration (2)     Index Management (1)     Search (1)     UDF (1)    
Advanced Querying (2)     Insert Update Stored Procedure Generation (1)     Security (1)     URL (1)    
Datetime Manipulation (2)     Maintenance and Management (1)     SQL 2005 (1)     User-defined function (1)    
games (2)     Management (1)     Stored Procedure Template (1)    

Search for any content tagged T-SQL

Add a script

   Items 1 to 20 of 35    Next 20 >>
 

A Sudoku solution with set based T-SQL utilizing binary operators.

A Sudoku solution with set based T-SQL approach utilizing binary values and operators, to ease the algorithm.  Read more...
By Kevin Duan 2008/06/16 | Source: SQLServerCentral.com | Category: T-SQL
Rating: |  Discuss |  Briefcase | 65 reads

Calculate Age

This a function by which you can calculate the age of something.  Read more...
By Maysarah 2008/05/23 | Source: SQLServerCentral.com | Category: T-SQL
Rating: (not yet rated) |  Discuss |  Briefcase | 45 reads

URLEncode

Here is a short UDF to URL encode a string. Requires a numbers table.  Read more...
By Robert Cary 2008/05/21 | Source: SQLServerCentral.com | Category: URL
Rating: |  Discuss |  Briefcase | 47 reads

Calculate Easter Date

A function to calculate the date for Easter Sunday for a given year  Read more...
By DASUN 2008/06/02 | Source: SQLServerCentral.com | Category: T-SQL
Rating: (not yet rated) |  Discuss |  Briefcase | 19 reads

Tic Tac Toe TSQL Style

This allows a player to play tic tac toe against an automated computer.  Read more...
By adam haines 2008/03/11 | Source: SQLServerCentral.com | Category: TSQL
Rating: |  Discuss |  Briefcase | 941 reads

Removing Duplicate Records

How to remove duplicate records from a table.  Read more...
By Semseddin Moldibi 2008/04/18 | Source: SQLServerCentral.com | Category: T-SQL
Rating: |  Discuss |  Briefcase | 1,853 reads

Generating permutations - procedure

This procedure prepares a query for generating permutations of n-numbers set and executes it.  Read more...
By Rafal S. 2008/03/18 | Source: SQLServerCentral.com | Category: Miscellaneous
Rating: |  Discuss |  Briefcase | 361 reads

Enable Disable All Triggers in a Database

Enable Disable All Triggers in a Database  Read more...
By vinaykumar 2008/03/20 | Source: SQLServerCentral.com | Category: T-SQL
Rating: |  Discuss |  Briefcase | 579 reads

Print The Calender

It shows the Calender.  Read more...
By vinaykumar 2008/03/14 | Source: SQLServerCentral.com | Category: T-SQL
Rating: |  Discuss |  Briefcase | 910 reads

Discover Unique Columns

Tool to automatically query combinations of columns in your table to determine candidate for unique key.  Read more...
By Jesse McLain 2008/04/16 | Source: SQLServerCentral.com | Category: T-SQL
Rating: (not yet rated) |  Discuss |  Briefcase | 422 reads

Identify Large Tables

Reports on physical size of tables in your database to identify largest.  Read more...
By Jesse McLain 2008/03/13 | Source: SQLServerCentral.com | Category: T-SQL
Rating: |  Discuss |  Briefcase | 746 reads

Parse the dependency chain of an object

Parses up & down the dependency chain of an object  Read more...
By Jesse McLain 2008/02/26 | Source: SQLServerCentral.com | Category: T-SQL
Rating: |  Discuss |  Briefcase | 784 reads

Generate INSERT for table with IDENTITY column

Generate a "INSERT INTO...SELECT FROM" script for a table with an identity column.  Read more...
By Jesse McLain 2008/03/07 | Source: SQLServerCentral.com | Category: T-SQL
Rating: |  Discuss |  Briefcase | 769 reads

Don't forget the Title

When using the output for generated code don't forget the title  Read more...
By Absinthe 2008/02/18 | Source: SQLServerCentral.com | Category: T-SQL
Rating: |  Discuss |  Briefcase | 622 reads

Modify columns' name in batches

Modify columns' name in batches.  Read more...
By hxd001_810 2008/02/14 | Source: SQLServerCentral.com | Category: T-SQL
Rating: |  Discuss |  Briefcase | 500 reads

Change column type on constrained columns

Use this proc if you need to alter a column that is part of a primery key  Read more...
By Luiz Barros 2008/02/04 | Source: SQLServerCentral.com | Category: Referential Integrity
Rating: (not yet rated) |  Discuss |  Briefcase | 479 reads

String Tokenizer with Complex Search

Sample solution to replace string in expressions with multiple delimiters.  Read more...
By tsaftalov 2008/01/31 | Source: SQLServerCentral.com | Category: String Manipulation
Rating: |  Discuss |  Briefcase | 734 reads

Refresh All Views

Refresh All views in Current Database.  Read more...
By BeoWulf . 2008/01/28 | Source: SQLServerCentral.com | Category: T-SQL
Rating: |  Discuss |  Briefcase | 572 reads

Split by Row & Field delimitters

Like my tdard split but this will take a string and split it by 2 delimiters  Read more...
By Reddy Software Solutions 2007/12/28 | Source: SQLServerCentral.com | Category: String Manipulation
Rating: |  Discuss |  Briefcase | 839 reads

Find occurence of any value in database!

Search entire database for occurrence of any text!  Read more...
By Reddy Software Solutions 2007/12/31 | Source: SQLServerCentral.com | Category: Search
Rating: |  Discuss |  Briefcase | 1,548 reads
   Items 1 to 20 of 35    Next 20 >>
 
Most popular

Insert Update Stored Procedure for a table

Generic Script for Insert Update Stored Procedures  Read more...
By Prasad Bhogadi 2007/12/06 | Source: SQLServerCentral.com | Category: T-SQL
Rating: |  Discuss |  Briefcase | 7,434 reads

Tic Tac Toe TSQL Style

This allows a player to play tic tac toe against an automated computer.  Read more...
By adam haines 2008/03/11 | Source: SQLServerCentral.com | Category: TSQL
Rating: |  Discuss |  Briefcase | 941 reads

How to empty database

Sometimes you need to empty the content of database. Following script can do that for you.  Read more...
By Boka | Source: SQLServerCentral.com | Category: T-SQL
Rating: |  Discuss |  Briefcase | 1,494 reads
 
Copyright © 2002-2008 Simple Talk Publishing. All Rights Reserved. Privacy Policy. Terms of Use