SQL with Dustin Ryan

Blogs

2 Tips to a Working Schedule

By

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

Monitoring SQL Server Performance with the Pure Storage FlashArray OpenMetrics Exporter

By

I’m excited to share a new open-source project I’ve been working on that combines...

Teaching at the SC Statewide Audit Conference

By

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

Read the latest Blogs

Forums

Food Testing Laboratory at Fare Labs Pvt. Ltd.

By farelabs

A NABL-accredited food testing facility, FARE Labs Pvt.Ltd. offers top-notch services for food and...

Why Clone Fails: Discovering the Hardware Beneath Azure SQL MI

By Tonie Huizer

Comments posted to this topic are about the item Why Clone Fails: Discovering the...

A Well Deserved Break

By Steve Jones - SSC Editor

Comments posted to this topic are about the item A Well Deserved Break

Visit the forum

Question of the Day

Multiple Defaults

In my SQL Server 2022 database, I run this code:

ALTER TABLE dbo.OrderHeader 
ADD ModifiedStamp DATETIME CONSTRAINT df_Created_Getdate DEFAULT GETDATE()
GO
I decide I need to add auditing to another table and run this:
ALTER TABLE dbo.Tracker
ADD Created DATETIME CONSTRAINT df_Created_Getdate DEFAULT GETDATE()
GO
What happens with these statements?

See possible answers