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,873 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,873 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,938 reads
2013-11-15
2,002 reads
2013-09-23
2,340 reads
By Steve Jones
I had someone ask me about using triggers to detect changes in their tables....
After spending decades working in SQL Server, getting familiar with PostgreSQL felt like traveling...
By Steve Jones
This month we have a great invite from Joe Fleming, a first time host...
Hello, I have a SQL Server with an AlwaysOn configuration consisting of three replicas...
Anyone got any good advice for performance tuning CDC on a Managed Instance? We...
Comments posted to this topic are about the item The Trigger Updated Column(s)
In a trigger, I can use UPDATE() or UPDATED_COLUMNS() to determine which columns were changed. For these functions, which one accepts a column name as a parameter?
See possible answers