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 […]

2004-12-17 (first published: )

735 reads

Blogs

T-SQL Tuesday #137–Notebook Uses

By

It’s actually my month to host T-SQL Tuesday, and I came up with the...

Daily Coping 13 Apr 2021

By

I started to add a daily coping tip to the SQLServerCentral newsletter and to...

Converting a SQL Server Docker image to a WSL2 Distribution

By

Windows Subsystem for Linux is probably my favourite feature of Windows 10. It gives...

Read the latest Blogs

Forums

connect to mdf file of localDB

By snomadj

Potentially dumb question.  There is 1 x ldf & 1 x mdf for DB1. ...

Incorrect update

By marcin89

Hello, I made mistake during updating cells in table.In column that contains int type,...

Log Shipping version upgrade oddity

By matt_murdock

Hi, I've come across an odd situation, and was wondering if anyone can explain...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers