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,536 reads
2008-09-19 (first published: 2008-07-20)
1,485 reads
2008-09-08 (first published: 2008-07-20)
1,271 reads
2008-07-20
2,007 reads
2008-07-20
1,618 reads
2008-01-29 (first published: 2007-11-23)
1,965 reads
2008-01-28 (first published: 2007-12-03)
1,699 reads
Clear all the data from tables
This script will delete all rows from the database, except system tables.
2007-11-26 (first published: 2007-09-30)
1,701 reads
2007-11-16
3,284 reads
2007-11-08
2,895 reads
Blogs
PowerPoint to HTML with Claude AI
By Steve Jones
I had an idea for an animated view of a sales tool, and started...
Don’t Miss Out – SQL Server Query Tuning Fundamentals Starts Next Monday!
Next Monday, February 9, 2026, my one-day live online training SQL Server Query Tuning...
Monday Monitor Tips: SQL Auditing Preview
By Steve Jones
One of the features we advocates have been advocating for is a better way...
Forums
SSRS shared dataset parameters not showing in expression builder
I am creating shared datasets that our executive staff can use for creating reports...
SSRS shared dataset parameters not showing in expression builder
I am creating shared datasets that our executive staff can use for creating reports...
Delta Lake: The Definitive Guide: Modern Data Lakehouse Architectures with Data Lakes
Comments posted to this topic are about the item Delta Lake: The Definitive Guide:...
Question of the Day
The Decoded Value
In SQL Server 2025, what is returned from this code:
DECLARE @message VARCHAR(50) = 'Hello SQL Server 2025!'; DECLARE @encoded VARCHAR(MAX); SET @encoded = BASE64_ENCODE(CAST(@message AS VARBINARY(1000))); SELECT BASE64_DECODE(@encoded)See possible answers