Category: SQL

InSQL
When working with SQL databases, you may find there are things you need to do which although seemingly basic on the surface, are easy to forget due to nuances in query syntax and the required ordering of statements. For these situations, it is useful to have a working example to refer to which reminds you…
InSQL
When implemented correctly, SQL Server Triggers are a powerful mechanism for adding useful functionality to a database without the need to change any application code. In this article, I look at what a SQL Server Trigger is, a template for a defining a new Trigger and possible use cases. A few facts You may already…