Answered by:
How to pass Parameters into Trigger in sql server 2005.

Question
-
Hello
I want to pass parameters into Trigger in sql server 2005.
Tell me what is the syntax to pass parameters into trigger.- Moved by Tony Petrossian Thursday, June 26, 2008 5:16 PM off topic
Monday, June 23, 2008 11:20 AM
Answers
-
Radhey,
You cannot pass parameters into a trigger. A trigger is executed automatically upon a data modification has been made on a table, and can't be called directly.
Why would you want to pass a parameter into a trigger? What is the problem you're trying to solve?
Dean- Marked as answer by Ed Price - MSFTMicrosoft employee Tuesday, September 25, 2012 10:39 PM
Monday, June 23, 2008 4:51 PM -
Hello all,
this forum is for SQL Server Data Services (SSDS). The attached link woill guide you to the appropriate forums, which would help provide you with the accurate and timely answers to the queries, that you have
http://msdn.microsoft.com/en-us/sqlserver/default.aspx
Thanks
Anil- Proposed as answer by Anilred Monday, June 23, 2008 9:17 PM
- Marked as answer by Ed Price - MSFTMicrosoft employee Tuesday, September 25, 2012 10:39 PM
Monday, June 23, 2008 9:17 PM -
Or if you'd like to find where to ask your question, you can ask here: http://social.technet.microsoft.com/Forums/en-US/whatforum/threads
Thanks!
Ed Price (a.k.a User Ed), SQL Server Experience Program Manager (Blog, Twitter, Wiki)
- Marked as answer by Ed Price - MSFTMicrosoft employee Tuesday, September 25, 2012 10:54 PM
Tuesday, September 25, 2012 10:39 PM
All replies
-
Radhey,
You cannot pass parameters into a trigger. A trigger is executed automatically upon a data modification has been made on a table, and can't be called directly.
Why would you want to pass a parameter into a trigger? What is the problem you're trying to solve?
Dean- Marked as answer by Ed Price - MSFTMicrosoft employee Tuesday, September 25, 2012 10:39 PM
Monday, June 23, 2008 4:51 PM -
Hello all,
this forum is for SQL Server Data Services (SSDS). The attached link woill guide you to the appropriate forums, which would help provide you with the accurate and timely answers to the queries, that you have
http://msdn.microsoft.com/en-us/sqlserver/default.aspx
Thanks
Anil- Proposed as answer by Anilred Monday, June 23, 2008 9:17 PM
- Marked as answer by Ed Price - MSFTMicrosoft employee Tuesday, September 25, 2012 10:39 PM
Monday, June 23, 2008 9:17 PM -
Or if you'd like to find where to ask your question, you can ask here: http://social.technet.microsoft.com/Forums/en-US/whatforum/threads
Thanks!
Ed Price (a.k.a User Ed), SQL Server Experience Program Manager (Blog, Twitter, Wiki)
- Marked as answer by Ed Price - MSFTMicrosoft employee Tuesday, September 25, 2012 10:54 PM
Tuesday, September 25, 2012 10:39 PM