这个存储该怎么写?

[vclzy]

create procedure tj
@m_yue varchar(10)
begin
insert table(kh,zh,name,@m_yue)
select kh,zh,name,zh*zj
from table
end

执行报@m_yue有错误,如果不能用变量,那该怎么写哦

[vclzy]

exec('insert table(kh,zh,name,'+@m_yue+') select kh,zh,name,zh*zj from table
where kh='' and zh='xxx' ')

我加个条件,怎么就报错哦,说有未闭合的'号

[marco08]

--try



exec('insert table(kh,zh,name,'+@m_yue+') select kh,zh,name,zh*zj from table
where kh='''' and zh=''xxx'' ')

[ppypym]

exec('insert table(kh,zh,name,'+@m_yue+') select kh,zh,name,zh*zj from table')

[rookie_one]

create procedure tj
@m_yue varchar(10)
begin
insert table(kh,zh,name,@m_yue)
select kh,zh,name,zh*zj
from table
end

执行报@m_yue有错误,如果不能用变量,那该怎么写哦
------------------------

你的table表如果是3列的话，这样是无法插入的
不如这样插入新表 select * into 新表 from(select kh,zh,name,zh*zj from table)t

[zhuqiang9]

create procedure tj

@m_yue varchar(10)
as ---加下
begin
insert table(kh,zh,name,@m_yue)
select kh,zh,name,zh*zj
from table
end
少個as

[study9]

create procedure tj
@m_yue varchar(10)
as
declare @stringa string
select @stringa='insert table(kh,zh,name,'
+@m_yue
+')select kh,zh,name,zh*zj from table'
execute (@stringa)
end