sql 提示语法错误，各位大婶看看啥问题

[vipyaoyuansheng]

检查了好几遍都看不不来
alter procedure bitchInsertUsers
as
declare @Num int
Declare @stringSql varchar(4000)
set @Num=1
while (@Num<2)
begin
set @stringSql=@stringSql+'insert into Users (ID,UserName,Password,sex,phone,email,CID) values('
+ Convert(varchar(36),newid())+','+Convert(varchar(50),@Num)+','+Convert(varchar(50),'123456')
+','+Convert(smallint,0)+' ,'+Convert(varchar(11),'12345698710')+','+Convert(varchar(50),'22988@qqc.c')
+','+Convert(varchar(18),'123456789123654')+') '

set @Num=@Num+1
print @stringSql
end


执行时
exec bitchInsertUsers

报错为：

消息 245，级别 16，状态 1，过程 bitchInsertUsers，第 8 行
在将 varchar 值 ' ,' 转换成数据类型 smallint 时失败。

[發糞塗牆]

alter procedure bitchInsertUsers
as
declare @Num int 
Declare @stringSql varchar(4000)
set @Num=1
while (@Num<2)
begin
set @stringSql=@stringSql+'insert into Users (ID,UserName,Password,sex,phone,email,CID) values('
     + Convert(varchar(36),newid())+','+Convert(varchar(50),@Num)+','+Convert(varchar(50),'123456')
 +','+Convert(VARCHAR,0)+' ,'+Convert(varchar(11),'12345698710')+','+Convert(varchar(50),'22988@qqc.c')
 +','+Convert(varchar(18),'123456789123654')+')  '


set @Num=@Num+1
EXEC  @stringSql
END
go

exec bitchInsertUsers

[vipyaoyuansheng]

引用 1 楼 DBA_Huangzj 的回复:

alter procedure bitchInsertUsers
as
declare @Num int 
Declare @stringSql varchar(4000)
set @Num=1
while (@Num<2)
begin
set @stringSql=@stringSql+'insert into Users (ID,UserName,Password,sex,phone,email,CID) values('
     + Convert(varchar(36),newid())+','+Convert(varchar(50),@Num)+','+Convert(varchar(50),'123456')
 +','+Convert(VARCHAR,0)+' ,'+Convert(varchar(11),'12345698710')+','+Convert(varchar(50),'22988@qqc.c')
 +','+Convert(varchar(18),'123456789123654')+')  '


set @Num=@Num+1
EXEC  @stringSql
END
go

exec bitchInsertUsers

提示找不到存储过程 消息 2812，级别 16，状态 62，过程 bitchInsertUsers，第 16 行 找不到存储过程 ''。

[發糞塗牆]

alter procedure bitchInsertUsers
as
declare @Num int 
Declare @stringSql varchar(4000)
set @Num=1
while (@Num<2)
begin
set @stringSql=@stringSql+'insert into Users (ID,UserName,Password,sex,phone,email,CID) values('
     + Convert(varchar(36),newid())+','+Convert(varchar(50),@Num)+','+Convert(varchar(50),'123456')
 +','+Convert(VARCHAR,0)+' ,'+Convert(varchar(11),'12345698710')+','+Convert(varchar(50),'22988@qqc.c')
 +','+Convert(varchar(18),'123456789123654')+')  '
 
 
set @Num=@Num+1
EXEC  (@stringSql)
END
go

[---涛声依旧---]

Convert(smallint,0)改为Convert(varchar,0)就行了

[---涛声依旧---]

或者直接 将 +','+Convert(VARCHAR,0)+ 改为 +',0'+