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
data
Search for
any
content tagged
data
Add a script
Items 1 to 3 of 3
Search for String in all columns
Find all columns containing a string value across all tables and schemas.
Read more...
By
Wes Henriksen
2012/11/07
|
Source:
SQLServerCentral.com
|
Category:
search
Rating:
|
Discuss
|
Briefcase
|
1,394 reads
Generate MERGE statements with Table data
A stored procedure that produces a MERGE statement for a given table containing a VALUES clause for all rows, useful for migrating static data between environments.
Read more...
By
Daniel Nolan
2012/10/08
|
Source:
SQLServerCentral.com
|
Category:
generate
Rating:
|
Discuss
|
Briefcase
|
2,587 reads
Function to Add Leading 0's (Zeros) to an INT
Very simple function code to add leading zeros to a passed in int for a length also passed.
Read more...
By
Joshua A. Walker
2009/03/05
|
Source:
SQLServerCentral.com
|
Category:
data warehousing
Rating:
|
Discuss
|
Briefcase
|
1,540 reads
Items 1 to 3 of 3
Copyright © 2002-2013 Simple Talk Publishing. All Rights Reserved.
Privacy Policy.
Terms of Use.
Report Abuse.