2012-08-24 (first published: 2007-09-29)
1,691 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,385 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,347 reads
2009-10-21 (first published: 2009-10-01)
2,298 reads
2008-10-10 (first published: 2008-07-20)
1,885 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,537 reads
2008-09-19 (first published: 2008-07-20)
1,486 reads
2008-09-08 (first published: 2008-07-20)
1,272 reads
2008-07-20
2,007 reads
2008-07-20
1,619 reads
Blogs
A New Word: on tenderhooks
By Steve Jones
on tenderhooks – adj. feeling the primal satisfaction of being needed by someone, which...
Ramblings about data communities and your contributions, no excuses
By DataOnWheels
I have been active in the data community throughout my career. I have met...
SQL Server Journey till 2025 (brief)
By Vinay Thakur
Quick Summary for Microsoft SQL Server till 2025, I am fortunate to be part...
Forums
how do i map the "current" object entry in for each to one variable
hi, in an ssis for each loop over an object variable called MyListVariable, i...
Simulating Mercury’s Orbital Motion Using Pure T-SQL (NASA 2025 Dataset)
SQL Server is typically viewed as a transactional or analytical database engine. However, it...
Azure SQL Database | CREATE EVENT SESSION [Blocking_Capture] ON DATABASE
Hello, Is there a way in Azure SQL Database to change the 'Blocking Process...
Question of the Day
String Similarity I
On SQL Server 2025, when I run this, what is returned?
SELECT EDIT_DISTANCE_SIMILARITY('SQL Server', 'MySQL') See possible answers