SQL 存储过程P:往表A(id,name)中插入数据,id为主键自增,name是“t+时间+序列号”的组合字符串
declare@namenvarchar(20)set@name='t'+CONVERT(varchar(100),GETDATE(),112)insertintoA(n...
declare @name nvarchar(20)
set @name = 't'+ CONVERT(varchar(100), GETDATE(), 112)
insert into A( name )values( @name+ cast((select count(*) from A (nolock))+1 as varchar) )
SELECT @@IDENTITY as ID
报错:Procedure or function P has too many arguments specified.
求教这个应该怎么改 ??? 在线等 展开
set @name = 't'+ CONVERT(varchar(100), GETDATE(), 112)
insert into A( name )values( @name+ cast((select count(*) from A (nolock))+1 as varchar) )
SELECT @@IDENTITY as ID
报错:Procedure or function P has too many arguments specified.
求教这个应该怎么改 ??? 在线等 展开
1个回答
推荐律师服务:
若未解决您的问题,请您详细描述您的问题,通过百度律临进行免费专业咨询