Angela

I started out as a software developer back in 1996 in Denver, CO, doing Client/Server development in PowerBuilder. I am now a Data Architect, living in High Point, NC and I love what I do. I’ve worked with all versions of SQL Server since the infamous split from the Sybase code (a.k.a. version 4.21a). I’ve worn all the hats that come with dealing with SQL Server, developer to data architect and everything in between. Mastodon handle: @SQLSwimmer

All authors

Blog Post

Don’t Forget To Take Break

So many times we get sucked into a rabbit whole when fixing/troubleshooting things we forget to take a break.  More often than not this leads to the “not seeing...

2019-01-23

3 reads

Blog Post

Speaking at DataGrillen

After speaking at SQL Saturday Iceland last year, which is a smaller event that I absolutely loved (you can read about that adventure here), I decided I wanted to...

2019-01-04

4 reads

All authors

Blogs

Understanding Zonal Redundancy in Azure SQL MI

By

Do you know what happens when you enable zonal redundancy for your SQL managed...

SQL Server Database Compatibility Levels

By

Why You Shouldn’t Overlook This Quiet but Critical SQL Server Setting   If you’ve...

The PASS Summit on Tour in the Netherlands

By

The PASS Summit goes on tour this year, with the final date the first...

Read the latest Blogs

Forums

How a Legacy Logic Choked SQL Server in a 30-Year-Old Factory

By Chandan Shukla

Comments posted to this topic are about the item How a Legacy Logic Choked...

Top Quality Boomerang Booth Rental for Corporate Events

By Sam1Parker

Make your corporate events more engaging with a fun twist. Our booths capture energetic...

How do I make this one row per id

By ajillity81

I've written this code, but it is showing right now as 2 rows per...

Visit the forum

Question of the Day

The Updated Columns List

I have this table in SQL Server 2022: 

CREATE TABLE CustomerLarge
  (CustomerID               INT NOT NULL IDENTITY(1, 1) CONSTRAINT CustomerLargePK PRIMARY KEY CLUSTERED
 , CustomerName             VARCHAR(20)
 , CustomerContactFirstName VARCHAR(40)
 , CustomerContactLastName  VARCHAR(40)
 , Address                  VARCHAR(20)
 , Address2                 VARCHAR(20)
 , City                     VARCHAR(20)
 , CountryCode              CHAR(3)
 , Postal                   VARCHAR(20)
)
GO
If I check the columns_updated() function return in a trigger, what is the data returned?

See possible answers