Simple SQL Server

Blogs

Teaching at the SC Statewide Audit Conference

By

Instead of teaching the CISA exam prep course, I'm teaching in the IT track....

Upgrading SQL Server in a Container

By

I decided to update software on my laptop recently during a trip. I’m loathe...

SQL Server Editions: What’s the Difference and Why It Matters

By

Understanding the Limits Before You Hit Them If you’re responsible for a SQL Server...

Read the latest Blogs

Forums

is there a reorg available in sql server?

By stan

hi i have a 67 million row fact table that needs about 30 million...

The Technical Debt Anchor

By Steve Jones - SSC Editor

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

Getting the Updated Column List

By Steve Jones - SSC Editor

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

Visit the forum

Question of the Day

Getting the Updated Column List

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

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

SELECT COLUMNS_UPDATED()

See possible answers