Some of the common SQL Server interview questions around DML triggers are: How does one identify active v/s disabled triggers and their corresponding trigger events? How can one determine if a trigger is an instead of trigger or not? Today's post presen...

...

Should return one row with one column called 'name' and value 20000. In inner query _________ is column alias, in outer query it's name changed using alias to 'name'. Underscore is valid symbol in aliases and identifiers' names...

Data security is the cornerstone of every business application. There is no arguing to the fact that confidential information needs to be protected by overlapping layers of security. Another aspect of security is data integrity....

...

I've used ANY and ALL in my queries...

Have you ever tried to write T-SQL code that conforms completely to the ISO standard? Since Microsoft SQL Server's T-SQL standard is based on the ISO standard, doing so is quite possible. Today, I explore the ISO equivalents of the EXISTS keyword - SOME...

Forgetting the "sa" login is an issue frequently seen in development & QA environments. Generally the Windows login works, but in some cases the IT team who installed the server may have forgotten to add someone to the sysadmin role. This post provides ...

...

...