The Mysterious Case of the Missing Default Value
Sometimes things are not exactly how we think they are. Read the story of the missing default value and learn why.
2017-03-24 (first published: 2015-12-01)
6,878 reads
Sometimes things are not exactly how we think they are. Read the story of the missing default value and learn why.
2017-03-24 (first published: 2015-12-01)
6,878 reads
Database ownership is an old topic for SQL Server pro's. Check this simple lab to learn the risks your databases can be exposed to.
2015-01-29
10,951 reads
2013-11-15
2,002 reads
2013-09-23
2,340 reads
By Brian Kelley
When I watched the following video from Justin Sung, I realized that I am...
I’m excited to share a new open-source project I’ve been working on that combines...
By Brian Kelley
Instead of teaching the CISA exam prep course, I'm teaching in the IT track....
Comments posted to this topic are about the item Why Clone Fails: Discovering the...
Comments posted to this topic are about the item A Well Deserved Break
Comments posted to this topic are about the item 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() GOI 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() GOWhat happens with these statements? See possible answers