插入出错

[Eric1006]

Select @count=COUNT(DISTINCT ci_customid) from db_custominfo
select @str=N'insert into custommakeup (cm_zone,cm_industdegree,'+@c_class+N') values ('''+@z_zone+N''','''+@id_industdegree+N''','''+@count+N''')'
print @str

其中@z_zone='ABC',@id_industdegree='DE'

总是出错：
将 nvarchar 值 'insert into custommakeup (cm_zone,cm_industdegree,IT) values ('ABC','DE','' 转换为数据类型为 int 的列时发生语法错误。

[CrazyFor]

Select @count=isnull(COUNT(DISTINCT ci_customid),0) from db_custominfo
select @str=N'insert into custommakeup (cm_zone,cm_industdegree,'+@c_class+N') values ('''+@z_zone+N''','''+@id_industdegree+N''','''+@count+N''')'
print @str

[CrazyFor]

Select @count=isnull(COUNT(DISTINCT ci_customid),0) from db_custominfo
select @str=N'insert into custommakeup (cm_zone,cm_industdegree,'+@c_class+N') values ('''+@z_zone+N''','''+@id_industdegree+N''','''+@count+N''')'
print @str

[CrazyFor]

Select @count=isnull(COUNT(DISTINCT ci_customid),0) from db_custominfo
select @str=N'insert into custommakeup (cm_zone,cm_industdegree,'+@c_class+N') values ('''+@z_zone+N''','''+@id_industdegree+N''','''+@count+N''')'
print @str

[pengdali]

Select @count=COUNT(DISTINCT ci_customid) from db_custominfo
select @str=N'insert into custommakeup (cm_zone,cm_industdegree,'+@c_class+N') values ('''+@z_zone+N''','''+@id_industdegree+N''','+cast(@count as nvarchar(10))+N')'
print @str

[愉快的登山者]

Select @count=COUNT(DISTINCT ci_customid) from db_custominfo
select @str=N'insert into custommakeup (cm_zone,cm_industdegree,'+@c_class+N')
values ('''+@z_zone+N''','''+@id_industdegree+N''','''+cast(@count as char)+N''')'
print @str


愉快的登山者

⊙
◢◣◢◣◢◣