Entity frame work has several advantages like below 1)Orm supprt: It is based on object relational mapping support,which maps between object and  data…

If anyone wants to output value with param definition , by below it can be done. SET @SQLString = N’SELECT @UserIDOUT = ‘…

For creating audit log this trigger can be used to fire trigger USE [PCCAS] GO /****** Object: Trigger [dbo].[Crime_AuditLog] Script Date: 04/29/2014 18:36:02…

It is very good question for interview to select this question, this is really very good question to ask. SELECT @@IDENTITY It returns…

At the time of creating Trigger on any table which includes  nvarchar,ntext, image field then an error can be seen for Cannot use…

it is great tools for selecting whole text of stored procedure,table etc . it is very easy to use for dynamic query without…