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