插入出错
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 的列时发生语法错误。