Tag Archives: T-SQL

I saw an article recently about implicit transactions and coincidentally, I had a friend get caught by this. A quick post to show the impact of this setting. Another post for me that is simple and hopefully serves as an … Continue reading →

As part of a demo recently I was adding a default value to a new column with a simple DEFAULT and a value. Under the covers this creates a constraint, however, I want to ensure this is named explicitly and … Continue reading →

I had someone ask me about using triggers to detect changes in their tables. This is the third post in the series. The first one Another post for me that is simple and hopefully serves as an example for people … Continue reading →

I had someone ask me about using triggers to detect changes in their tables. This is a second post looking at triggers, in this case, modifying my trigger to detect more changes and using that information. Another post for me … Continue reading →