Amit Gaur

Convert String to a Table using CTE

Explains how to convert a list of Ids passed as string and convert it to a table

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

3.79 (63)

You rated this post out of 5. Change rating

2009-12-14

14,102 reads

Measuring and Improving SQL Server Query Plan Cache Efficiency The query...

I may think I'm trying to reach the crowd, but I'm really trying to...

During a demo of Redgate Monitor Enterprise to a customer, they asked about how...

Comments posted to this topic are about the item The Technical Debt Anchor

Comments posted to this topic are about the item Getting the Updated Column List

Here's the complete error: An error occurred during local report processing. The definition of...

What happens when I run this code in SQL Server 2022?

UPDATE dbo.CustomerLarge
 SET CustomerContactFirstName = 'Andy'
 WHERE CustomerID = 1

SELECT COLUMNS_UPDATED()