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.
Author |
Topic |
pnpsql
Posting Yak Master
246 Posts |
Posted - 2013-03-14 : 08:48:52
|
i want to execute a stored proc and insert all its values in a table. And i also want to insert an additional value with columns that are inserted bt sp. like my proc is : create procedure test_proc as select 1 as num union select 2 as numand my table is : create table test_ins(pid numeric(10) , num numeric(10) ) and when i run i want to insert @pid value in the table along with sp values. declare @pid numeric(10) = 999 insert into test_ins(pid , num ) exec test_prockindly helpchallenge everything |
|
|
|
|