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 /****** […]