<a href="http://g.adspeed.net/ad.php?do=clk&zid=15220&wd=468&ht=60&pair=as" target="_blank"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15220&wd=468&ht=60&pair=as" alt="i" width="468" height="60"/></a>
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
<a href="http://g.adspeed.net/ad.php?do=clk&zid=15491&wd=120&ht=300&pair=as" target="_top"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15491&wd=120&ht=300&pair=as" alt="i" width="120" height="300"/></a>
Content with tag
Reference
Items 1 to 5 of 5
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
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
'Just Google It'
A short editorial explaining the pitfalls of using search engines as reference for DBA's.
Read more...
By
Bas de Zwart
2010/08/05
|
Source:
SQLServerCentral.com
|
Category:
reference
Rating:
|
Discuss
|
Briefcase
|
285 reads
Date Calendar
Code to create a handy date calendar cross-reference table with a ton of pre-populated, slice-and-dice data field variations to aid in complex date parameterization / selection criteria.
Read more...
By
Sean Smith
2010/07/21
|
Source:
SQLServerCentral.com
|
Category:
date
Rating:
|
Discuss
|
Briefcase
|
5,175 reads
Date Calendar
Code to create a handy date calendar cross-reference table with a ton of pre-populated, slice-and-dice data field variations to aid in complex date parameterization / selection criteria.
Read more...
By
Sean Smith
2010/07/21
|
Source:
SQLServerCentral.com
|
Category:
date
Rating:
|
Discuss
|
Briefcase
|
5,175 reads
Items 1 to 5 of 5
Tags
calculate
(1)
calendar
(1)
complex
(1)
data
(1)
date
(1)
delete
(1)
domain
(1)
editorial
(1)
generate
(1)
google
(1)
insert
(1)
lookup
(1)
merge
(1)
migration
(1)
parameterization
(1)
populate
(1)
static
(1)
update
(1)
Copyright © 2002-2013 Simple Talk Publishing. All Rights Reserved.
Privacy Policy.
Terms of Use.
Report Abuse.
