Technical Article

Update multiple rows (in a set) using a single SP

Here is another variation of processing multiple records with a single procedure call but allowing for set processing.The helper functions make use of the sequencetable pattern. These helper functions can be used to parse strings into records, so one gets a list, or simply return the nth field.There are two functions that will parse into […]

You rated this post out of 5. Change rating

2004-12-17 (first published: )

775 reads

Blogs

Friday Flyway Tips: State-based deployment with Flyway Teams

By

I was asked about state-based deployments in Flyway Teams, so I decided to show...

Advice I Like: The Main Thing

By

The main thing is to keep the main thing the main thing. – from...

Sic Transit Gloria Community

By

When Covid took out the PASS organization, I had someone say to me, “Well,...

Read the latest Blogs

Forums

Dynamic T-SQL Script Parameterization Using Python

By omu

Comments posted to this topic are about the item Dynamic T-SQL Script Parameterization Using...

Log Shipping Not Able to Restore Log Files in Secondary

By regnar

I'm attempting to set up log shipping from SQL Server 2005 Standard to SQL...

Smile and Wave Boys

By Grant Fritchey

Comments posted to this topic are about the item Smile and Wave Boys

Visit the forum

Question of the Day

Counting Bits IV

What do these two selects return?

SELECT BIT_COUNT (CAST (-1 as smallint))
     , BIT_COUNT (CAST (-1 as bigint))

See possible answers