How to pass Parameters into Trigger in sql server 2005.

Answers

• 

  

  0

  Sign in to vote

  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
• 

  

  0

  Sign in to vote

  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
• 

  

  0

  Sign in to vote

  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