stored procedures in triggers - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2000 Forums

SQL Server Development (2000)

stored procedures in triggers

Author

Topic

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2003-07-03 : 07:56:19

sharma writes "how to call or execute stored procedures which returns values,in triggers?
need sample too!"

macka
Posting Yak Master

162 Posts

Posted - 2003-07-03 : 08:40:36


CREATE TRIGGER trgInsert ON dbo.SomeTable
FOR INSERT 
AS

SET NOCOUNT ON

DECLARE @i int

EXEC spSomeStoredProc @i OUTPUT

PRINT @i

GO

macka.

--
There are only 10 types of people in the world - Those who understand binary, and those who don't.

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources