Stored Procedure to Pause Execution
Ever needed to pause in a SQL script? Or wanted to simulate a long running process for testing? This stored procedure accepts an integer and pauses for that many seconds.
2002-10-04
1,222 reads
Ever needed to pause in a SQL script? Or wanted to simulate a long running process for testing? This stored procedure accepts an integer and pauses for that many seconds.
2002-10-04
1,222 reads
By Steve Jones
I was testing the new SSMS (v22 Preview 3) with Copilot and ran into...
By Kevin3NF
Don’t Let Trouble Sneak Up on You Most SQL Servers run quietly. Until...
By Steve Jones
I had a conversation with a customer asking this question: how can I tell...
Comments posted to this topic are about the item Create an HTML Report on...
Comments posted to this topic are about the item Building a RESTful API with...
Comments posted to this topic are about the item The Journey to PostgreSQL (or...
What happens when I run this code:
DECLARE @s VARCHAR(1000) = 'apple, pear, peach' SELECT * FROM STRING_SPLIT(@s, ', ')See possible answers