Advantages of Entity Framework
Entity frame work has several advantages like below 1)Orm supprt: It is based on object relational […]
For Using sp_executesql with param definition and output parameter
If anyone wants to output value with param definition , by below it can be done. […]
AuditLog Trigger
For creating audit log this trigger can be used to fire trigger USE [PCCAS] GO /****** […]
Differance between @@IDENTITY ,SCOPE_IDENTITY() and DENT_CURRENT(‘tablename’)
It is very good question for interview to select this question, this is really very good […]
Cannot use text, ntext, or image columns in the ‘inserted’ and ‘deleted’ tables
At the time of creating Trigger on any table which includes nvarchar,ntext, image field then an […]
select text using sp_helptext
it is great tools for selecting whole text of stored procedure,table etc . it is very […]