Sparse Column

Blogs

2 Tips to a Working Schedule

By

When I watched the following video from Justin Sung, I realized that I am...

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...

Read the latest Blogs

Forums

cant that export task be scripted without ssis

By stan

hi, i'm archiving some dw stuff to tsv's.   i got the manual sequence working...

Dependency Chain

By Phil Parkin

I have not yet been able to come up with a tidy solution for...

is there a reorg available in sql server?

By stan

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

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

Cookies on SQLServerCentral

This website stores cookies on your computer.

These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.

To find out more about the cookies we use, see our Privacy Policy