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,521 reads
2008-09-19 (first published: 2008-07-20)
1,472 reads
2008-09-08 (first published: 2008-07-20)
1,262 reads
2008-07-20
1,997 reads
2008-07-20
1,587 reads
2008-01-29 (first published: 2007-11-23)
1,954 reads
2008-01-28 (first published: 2007-12-03)
1,688 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,694 reads
2007-11-16
3,280 reads
2007-11-08
2,888 reads
Blogs
DATEADD Truncates the Number Parameter: #SQLNewBlogger
By Steve Jones
This was an interesting thing I saw in a Question of the Day submission....
Our SQL Server is Slow! What Do I Do First?
By Kevin3NF
Don’t Panic! It’s a vague but common complaint, frequently with no additional details. Before...
Using SQLFluff
I thought I didn’t care about linting, and lately, I haven’t written a lot...
Forums
Dynamic T-SQL Script Parameterization Using Python
Comments posted to this topic are about the item Dynamic T-SQL Script Parameterization Using...
Eliminate a function by writing out the code is now throwing an error
/* I'm trying to eliminate (write out) this function 'largest_date', but SQL Server 2016...
SQL Server Migration - Redirecting Old Instance Connections to New AG Listener
Hi everyone, I’ve been tasked with migrating a Standalone SQL Server instance to a...
Question of the Day
A Strange Choice
What is returned when I run this code in SQL Server 2022?
CREATE TABLE CatIndex
( indexval VARCHAR(20)
)
GO
INSERT dbo.CatIndex (indexval) VALUES ('1'), ('2'), ('3')
GO
SELECT CHOOSE(indexval, cast('2025-01-01' AS DATE), CAST('2025-02-01' AS DATE), CAST('2025-03-01' AS DATE))
FROM dbo.CatIndex AS ci See possible answers