Imagine this procedure:
CREATE PROCEDURE [dbo].[insertActive] (
-- Add the parameters for the stored procedure here
@p_data dbo.activeUpdate readonly)
-- SET NOCOUNT ON added to prevent extra result sets from
-- interfering with SELECT statements.
insert into dbo.active (name,stateid) select name,stateid from @p_data
How can I get the ids of the rows that have been inserted? I tried searching the net and the forums but could not find anything.
Thanks for any and all help,
View Complete Post