How to pass parameter to trigger?

Question

Hello All I am using mvc5sql server and angular js.i want to mainten audit trail in my project.for that i need to mainten old data and new data.i am using trigger for that.but while fetching the oled records before edit i need to get that data by id using trigger.how to pass parameter in trigger using sql server.

Sandeep Kumar · Answer

Please follow below syntax create trigger Trigger_Name On table name Types of Trigger operation which have to perform //Insertion/deletion as begin declare parameter here statement end

Arul R · Answer

Kindly refer the below links Hope this will solve your problem. http://weblogs.asp.net/jongalloway/adding-simple-trigger-based-auditing-to-your-sql-server-database http://stackoverflow.com/questions/1962398/creating-audit-triggers-in-sql-server http://dba.stackexchange.com/questions/65644/trigger-to-audit-table-changes http://www.c-sharpcorner.com/UploadFile/37db1d/creating-and-managing-triggers-in-sql-server-20052008/ http://www.dotnet-tricks.com/Tutorial/sqlserver/OPUH170312-After-Trigger-Instead-of-Trigger-Example.html http://searchsqlserver.techtarget.com/feature/SQL-Server-trigger-example-One-trigger-vs-two-for-the-same-logic http://www.aspsnippets.com/Articles/Simple-Insert-Update-and-Delete-Triggers-in-SQL-Server-with-example.aspx http://www.aspsnippets.com/Articles/Simple-Insert-Update-and-Delete-Triggers-in-SQL-Server-with-example.aspx http://www.databasejournal.com/features/mssql/article.php/3837541/DML-Triggers-in-SQL-Server-2008.htm https://www.mssqltips.com/sqlservertip/2085/sql-server-ddl-triggers-to-track-all-database-changes/ Let me know for any thing more.... If your problem solved means kindly Accept my answer