Isolation Levels in SQL Server :- Locks are controlled by isolation levels, Types of isolation levels: Read uncommitted Read committed Serializable (I) Read uncommitted in SQL Server  :- If the isolation level is set to [...]

Locking in SQL Server :- Locking resolves of concurrent access where concurrent access means accessing same data by the number of users at same time. The following problem occurs concurrent  access: dirty [...]

CLR Integration in SQL Server :- The stored procedures & functions can also be created by using c# (or) VB. And the objects are called “CLR database objects” The difference [...]

XML Integration in SQL Server :- Xml is simple and Unicode And platform independent. Transfer data from one file to another For each record one tag is created with name “row” [...]

DDL Triggers in SQL Server :- It is introduced from sql server 2005. This triggers are created to control DDL operations like create,alter,drop. Syntax :-  create trigger <name>                         On database                     After [...]

DML Triggers in SQL Server  :- These triggers are created on particular table. These triggers are created to control DML operators. Syntax  :- Create /alter trigger <name> Or<tablename>/<viewname>   After/instead [...]

Database Triggers in SQL Server:- A database trigger is also a ‘named block’ like procedures executed implicitly. Procedures in SQL Server :                   [...]

Table Valued Functions in SQL Server  :- These functions returns set of records  i:e table. The return type of this functions must be “table”. The return expression is  ”select statement”. [...]

Function Types in SQL Server   :- It can be divided into two types Scalar valued Table valued Scalar Valued function in SQL Server:- These functions returns only one value of [...]

Functions in SQL Server :- A function is also a named tsql block takes some input performs a task and must returns a value. Difference between Procedures and Functions in SQL [...]