27,580
社区成员
发帖
与我相关
我的任务
分享
select * from openrowset('SQLOLEDB', 'Server=127.0.0.1;Database=master;Trusted_Connection=yes;', 'exec dbname..Proc_Table')
insert into #a exec proc_table
select * from #a
create procedure proc_table
@name varchar(20) output
as
begin
select * from table_name where name=@name
end
GO
EXEC proc_table '@name'
create procedure proc_table
@name varchar(20) output
as
begin
select * from table_name where name=@name
end
GO
EXEC proc_table '@name'
直接
exec 存储过程
错啦
exec 存储过程