How to pass parameter to trigger?

Hello All,

I am using mvc5,sql 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.

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.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

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

Sandeep Kumar10y ago
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
0
Arul R10y ago
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
0