Triggers in SQL Server

A trigger in SQL Server is a special kind of stored procedure that automatically executes when an event occurs in the database server. There are following types of triggers available in SQL Server, DML Triggers DDL Triggers Logon Triggers DML Triggers: DML Triggers get executed when a user tries to modify data through data manipulation […]

Read More

top 15 sql server interview questions with answers

Q. What is sub query and its properties? A. A sub-query is a query which can be nested inside a main query like Select, Update, Insert or Delete statements. This can be used when expression is allowed. Properties of sub query can be defined as A sub query should not have order by clause. A […]

Read More