Retrieve Output from SQL Statement using Execute Database Command
I have a SQL INSERT statement I am running which has an OUTPUT command to return the primary key of the data just inserted. The statement has been verified in SSMS and appears to succeed in TA5. However, I can't figure out how to get the returned value. In the Command Parameters I have listed the column Name, Type, Direction as "Output," and variable in Assigned Result To, but nothing comes out.
- 4 replies