我写了一个过程
但是检查时出错,请帮忙改正,或给一个新的过程,谢谢了。
代码如下:
CREATE PROCEDURE tianjia
( @biaoming varchar(20)=null,
@cheming varchar(20)=null output)
AS
create table @biaoming
( mingcheng varchar(20),
bianhao varchar(20),
danjia varchar(20),
jiezhang varchar(20),
leibian varchar(20),
xiaoliang varchar(20),
tupian varchar(50)
)
@[email protected]
return
------解决方案--------------------
--
CREATE PROCEDURE tianjia
(
@biaoming varchar(20)=null,
@cheming varchar(20)=null output
)
AS
exec( '
create table [ '[email protected]+ ']
( mingcheng varchar(20),
bianhao varchar(20),
danjia varchar(20),
jiezhang varchar(20),
leibian varchar(20),
xiaoliang varchar(20),
tupian varchar(50)
)
')
set @[email protected]
go
--
declare @re varchar(20)
exec tianjia 'AA ', @re output
select @re
select * from AA