Calling a stored procedure from T-SQL

[Bulldog13]

I have an insert trigger on TABLE_A. On insert into TABLE_A, it takes Inserted.SSN and Inserted.PK and puts them into a TABLE_B.


declare @SSN varchar(9);


INSERT INTO [dbo].[TABLE_B]
(SSN, ID)
SELECT INSERTED.SSN,
INSERTED.PK
From INSERTED

select @SSN = Inserted.ssn from inserted


I want to add onto this trigger so that I can run a stored procedure on the Inserted.SSN and retrieve the results.

exec dbo.spGet_Member_POC @SSN

[what t-sql magic here to capture the result ?]

 

[Markbnj]

In the procedure definition declare the parameter as OUTPUT. When calling the procedure use the keyword OUT after the parameter name. After the procedure returns you can select the value out of the parameter.

http://blog.4penny.net/blogs/s...output-parameters.aspx