2012-08-24 (first published: 2007-09-29)
1,663 reads
Get Modified Objects As on Date
This table Valued Function return the Modified Objects (SP /Views) For the Date specified.
2011-10-07 (first published: 2007-11-23)
1,371 reads
Ultimate Alter Script generator
In development enviornment we always get the modifications in tables from developers.As far as my concern writing scripts is tedious work for us. I hope below script will help you.
2009-10-30 (first published: 2009-10-01)
1,322 reads
2009-10-21 (first published: 2009-10-01)
2,257 reads
2008-10-10 (first published: 2008-07-20)
1,856 reads
Script to return Rows count from table using sp_ExecuteSQL
Script to return Rows count from table using sp_ExecuteSQL
2008-09-26 (first published: 2008-07-20)
1,516 reads
2008-09-19 (first published: 2008-07-20)
1,467 reads
2008-09-08 (first published: 2008-07-20)
1,261 reads
2008-07-20
1,988 reads
2008-07-20
1,535 reads
Blogs
Friday Flyway Tips–Comparison Options
By Steve Jones
Recently a customer asked how they could get index changes to be captured in...
A New Word: Guiltwrights
By Steve Jones
giltwrights – n. the imaginary committee of elders that keeps a running log of...
Becoming Kristyna Ferris <3
By DataOnWheels
Hey folks, fun personal post today. A few weeks ago, I got married! My...
Forums
JSON data with Pivoted
Hi All, I need some assistance and not sure how to achieve the expected...
SQL Window Functions Series: LAG() and LEAD()
Comments posted to this topic are about the item SQL Window Functions Series: LAG()...
Breaking Biometrics
Comments posted to this topic are about the item Breaking Biometrics
Ask SSC