OUTPUT clause has accesses to inserted and deleted tables (virtual tables) just like triggers. OUTPUT clause can be used to return values to client clause. OUTPUT clause can be used with INSERT, UPDATE, or DELETE to identify the actual rows affected by ...

In above post please replace Spwho2 with Sp_who2...

***Short Story Of Deadlock:*** Deadlocking occurs when two or more SQL Server processes have locks on separate database objects and each process is trying to acquire a lock on an object that the other processes have previously locked. For example, p...

*Collation is concerned with how character data is interpreted by SQL Server. Until you run into a problem concerning them, you’re probably blissfully unaware of their existence. The following error is easy to generate by joining columns of different co...

Below are the different locks inside the SQL server 2008 R2: Shared (S): Used for read operations that do not change or update data, such as a SELECT statement. Update (U) Used on resources that can be updated. Prevents a common form of deadlock ...

Here is the answer: With the below statement we can write a WHERE Clause to search names between A-J: select * From TABLE_NAME Where NAMES like '[A-J]%' Thanks, Deepti....