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: )

670 reads

Blogs

Power Platform Quick Tips – Episode 01: Fixing Power BI Column Sorting

By

Check out this new series that I’ve started on Power Platform Quick Tips. This...

The curious case of CHAR(0)

By

Over the years I’ve seen quite a few strange things with SQL Server. This...

Transaction log Information gathering

By

Here are the different ways to know the tlog file related information sys.dm_db_log_stats –...

Read the latest Blogs

Forums

Numeric and Decimal

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Numeric and Decimal, which is...

Backup file size 3X after shrinking the log file?

By mike1234321

Here's a head scratcher - I've not seen anything like this in 20+ years...

repeating block of records

By scott.laird

I want to look for blocks of records repeating in a table.   pattern...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers