create procedure myprocedure
@desttable varchar(30),
@sourcetable varchar(30)
AS
Exec('select t.序号,y.确认医院编号,t.采购数量,t.地区
into ' + @desttable + ' FROM ' + @sourcetable + ' t,YIYUAN y
where t.采购单位=y.医院名称 ')
@desttable varchar(30),
@sourcetable varchar(30)
AS
Exec('select t.序号,y.确认医院编号,t.采购数量,t.地区
into ' + @desttable + ' FROM ' + @sourcetable + ' t,YIYUAN y
where t.采购单位=y.医院名称 ')
@表名 varchar(100)
as
exec('select * from '+@表名)
@desttable varchar(30),
@sourcetable varchar(30)
AS
exec('select t.序号,y.确认医院编号,t.采购数量,t.地区
into '+@desttable+'
FROM '+@sourcetable+' t,YIYUAN y
where t.采购单位=y.医院名称')
@desttable varchar(30),
@sourcetable varchar(30)
AS
exec('select t.序号,y.确认医院编号,t.采购数量,t.地区
into '+@desttable+'
FROM '+@sourcetable+' t,YIYUAN y
where t.采购单位=y.医院名称')
@desttable varchar(30),
@sourcetable varchar(30)
AS
exec('select t.序号,y.确认医院编号,t.采购数量,t.地区
into '+@desttable+'
FROM '+@sourcetable+' t,YIYUAN y
where t.采购单位=y.医院名称
')