CREATE PROCEDURE SPty_LockedYejiID
(
@tablename char(10),
@id decimal (9),
@xuhao char(10)
)
AS
SET NOCOUNT OFF;exec('
select rowid = (count(1)+1 from '+@tablename+' where (xuhao='''+@xuhao+''')and(id< '''+@id+'''))
from '+@tablename+' a
')GO我这么写怎么没有语法错误 但执行有误啊
(
@tablename char(10),
@id decimal (9),
@xuhao char(10)
)
AS
SET NOCOUNT OFF;exec('
select rowid = (count(1)+1 from '+@tablename+' where (xuhao='''+@xuhao+''')and(id< '''+@id+'''))
from '+@tablename+' a
')GO我这么写怎么没有语法错误 但执行有误啊
exec('
select rowid = (select count(1)+1 from '+@tablename+' where (xuhao='''+@xuhao+''')and(id< '''+@id+'''))
from '+@tablename+' a
from '+@tablename+' a')