这个存储该怎么写?
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有错误,如果不能用变量,那该怎么写哦
[解决办法]
exec( 'insert table(kh,zh,name, '+@m_yue+ ') select kh,zh,name,zh*zj from table ')
[解决办法]
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
[解决办法]
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
[解决办法]
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
[解决办法]
--try
exec( 'insert table(kh,zh,name, '+@m_yue+ ') select kh,zh,name,zh*zj from table
where kh= ' ' ' ' and zh= ' 'xxx ' ' ')
