单引号 char(39)
declare @colnames nvarchar(2000)
set @colnames='depname,depcode'
declare @c1 varchar(200)
set @c1=char(39)+'分部1'+char(39)
declare @c2 varchar(200)
set @c2=char(39)+'002'+char(39)
declare @values varchar(1000)
set @values=@c1+','+@c2
exec addrecord 'ware_dep',@colnames,@values
insert into ware_dep(depname,depcode) values('分部1','002')