Log in
::
Register
::
Not logged in
Home
Tags
Articles
Editorials
Stairways
Forums
Scripts
Videos
Blogs
QotD
Books
Ask SSC
SQL Jobs
Training
Authors
About us
Contact us
Newsletters
Write for us
Scripts with tag
T-SQL
Search for
any
content tagged
t-sql
Add a script
Items 1 to 20 of 216
Next 20 >>
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
|
1,558 reads
who can do what?
list each user has the right to do
Read more...
By
Ricardo Leka
2011/10/31
|
Source:
SQLServerCentral.com
|
Category:
security
|
SQL Scripts Manager Compatible
Rating:
|
Discuss
|
Briefcase
|
1,337 reads
Different ways to write Distinct Query - MSSQL
Distinct Query
Read more...
By
Krishna Mohan Thamisetty
2011/11/01
|
Source:
SQLServerCentral.com
|
Category:
t-sql
Rating:
|
Discuss
|
Briefcase
|
1,833 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
|
761 reads
Convert string Hex to Numeric with inline TSQL
A fast way to convert a string containing Hex values to numeric
Read more...
By
Federico Iori
2011/11/09
|
Source:
SQLServerCentral.com
|
Category:
hexadecimal conversion numeric inline fast
Rating:
|
Discuss
|
Briefcase
|
498 reads
Grouping Sets
This script is to check for Queries returning same result set.
Read more...
By
Vaidya VS
2011/10/12
|
Source:
SQLServerCentral.com
|
Category:
t-sql
Rating:
|
Discuss
|
Briefcase
|
639 reads
Copy One Schema to Another Schema
This script copies one object in another multiple schema.
Read more...
By
Vinay Kumar
2011/08/31
|
Source:
SQLServerCentral.com
|
Category:
t-sql
Rating:
|
Discuss
|
Briefcase
|
799 reads
Change Time Zone on Server without Logging on to Box
Sometimes logging onto a box for a simple change like this is not possible for the business. This allows you to change this directly from T-SQL without having to log on or RDP into the box.
Read more...
By
Shirley Noa
2011/08/17
|
Source:
SQLServerCentral.com
|
Category:
time zone
Rating:
|
Discuss
|
Briefcase
|
333 reads
Verify a database backup using T-SQL
A script to verify a database backup using T-SQL code
Read more...
By
Nakul Vachhrajani
2011/07/11
|
Source:
SQLServerCentral.com
|
Category:
administration
Rating:
|
Discuss
|
Briefcase
|
1,223 reads
Remove tab,line feed and carriage return frome text field
Remove tab,line feed and carriage return frome text field
Read more...
By
Harsha Majety
2011/04/28
|
Source:
SQLServerCentral.com
|
Category:
t-sql
Rating:
|
Discuss
|
Briefcase
|
1,441 reads
Extend CHARINDEX with occurance matching
Retrieve the charindex of matching string for the desired occurrence
Read more...
By
Partha Pal
2011/04/13
|
Source:
SQLServerCentral.com
|
Category:
t-sql
Rating:
|
Discuss
|
Briefcase
|
1,073 reads
Append Value to Delimited List
Takes a delimited list and appends a value to the end.
Read more...
By
Chad Casady
2011/03/04
|
Source:
SQLServerCentral.com
|
Category:
udf
Rating:
|
Discuss
|
Briefcase
|
5,935 reads
String tokenizing / splitting
We often have need of string splitting in applications. I had need of one in some T-SQL development I am currently doing for a friend.
Read more...
By
Irfan Baig
2011/02/25
|
Source:
SQLServerCentral.com
|
Category:
string manipulation
Rating:
|
Discuss
|
Briefcase
|
1,605 reads
RowCount
Get the rowcount in all tables
Read more...
By
Pradyothana Shastry
2011/02/18
|
Source:
SQLServerCentral.com
|
Category:
t-sql
Rating:
|
Discuss
|
Briefcase
|
2,455 reads
Stored procedure to script tables, has many options
I needed a fast way of creating identical copies of multiple tables. The criteria was to make identical copies of tables for a specific schema. Well there it started.
Read more...
By
Gokhan Varol
2011/02/01
|
Source:
SQLServerCentral.com
|
Category:
t-sql
Rating:
(not yet rated)
|
Discuss
|
Briefcase
|
1,972 reads
Issues with IsDate()
IsDate function returns 1 for a numeric value
Read more...
By
Kameswari Aravindh
2011/01/28
|
Source:
SQLServerCentral.com
|
Category:
t-sql
Rating:
|
Discuss
|
Briefcase
|
1,233 reads
SQL Function to get Max, Min values from given collection of values
This func returns the max value,min value and count of values from collection of values
Read more...
By
Bharat Panthee
2011/01/20
|
Source:
SQLServerCentral.com
|
Category:
aggregates
Rating:
|
Discuss
|
Briefcase
|
1,381 reads
SQL CLR Function for Email validation and string Split
I have added 2 functions here, one for email validation and another to split the string by specified separator by user.
Read more...
By
Bharat Panthee
2010/12/23
|
Source:
SQLServerCentral.com
|
Category:
t-sql
Rating:
|
Discuss
|
Briefcase
|
1,040 reads
SQL Script to generate columns for triggers
SQL Script to generate columns for triggers
Read more...
By
DBLACKWELL
2010/12/27
|
Source:
SQLServerCentral.com
|
Category:
t-sql
Rating:
|
Discuss
|
Briefcase
|
916 reads
Eval arithmetic statement function in SQL
This function evaluates the statement like '4+5*6-3' and returns the numeric value.It is just like Eval funcction in javascript.
Read more...
By
Bharat Panthee
2010/12/15
|
Source:
SQLServerCentral.com
|
Category:
t-sql
Rating:
|
Discuss
|
Briefcase
|
874 reads
Items 1 to 20 of 216
Next 20 >>
Copyright © 2002-2012 Simple Talk Publishing. All Rights Reserved.
Privacy Policy.
Terms of Use.
Report Abuse.