hello,
the stored proc sp_help_job @.execution_status = 1 return
one row.
How can I insert this row to a table? Can I write a
statemate like:
Select *
into tableA
from
(exec sp_help_job @.execution_status = 1)
Can anybody tell me how to do it?
Thanks a lot...hi Harry,
See following example.
CREATE TABLE #Temp1
(
spid varchar(32),
dbid real,
objid real,
indid int,
type varchar(50),
resource varchar(50),
mode varchar(5),
status varchar(5)
)
-- following is the syntax.
INSERT INTO #Temp1 EXEC sp_lock
-- Vishal
Friday, March 9, 2012
How can I insert SP's result set to a table
Labels:
astatemate,
database,
execution_status,
insert,
likeselect,
microsoft,
mysql,
oracle,
proc,
returnone,
row,
server,
sp_help_job,
sql,
stored,
table,
write
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment