22,209
社区成员
发帖
与我相关
我的任务
分享
master.dbo.xp_execresultset N'create proc[table|trigger]...','dbname'
--这样好像可以
create procedure cssd
as
begin
exec (' USE WMS create procedure E1 as begin select 2 end')
end
use test
create procedure dbo.cssd
as
begin
select 1 from test.dbo.sysobjects
select 2 from WMS.dbo.sysobjects
end