SQL Roadie

Blog Post

Where is your Awesome?

Everyone of us is in a perpetual pursuit of awesomeness - some actively looking for it, while others passively. Either way, it is inherent in our making to reach...

2020-09-11 (first published: )

424 reads

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

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

Multiple Defaults

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Multiple Defaults

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