???? 存在三种状态的记录，一个是禁用的，一个是可用的，一个是已经删除的。

create procedure getCheckTableData?
(@tableName varchar(100),@oldIStatus varchar(100),@cSourceGUIDS varchar(6000),@data varchar(1000) output)
as
declare?
??????? @iStatus int,
??????? @newIStatus varchar(100),
??????? @cGUID varchar(18),
??????? @sql nvarchar(4000)
?
?? set @newIStatus ='iStatus'
?? begin
?? if(@oldIStatus <>'')
???? set @newIStatus=@oldIStatus
?? end
? set?? @cSourceGUIDS=@cSourceGUIDS+';'?
?? print @cSourceGUIDS
? while(@cSourceGUIDS<>'')??
?????? begin??
??????????????????????? set @cGUID=left(@cSourceGUIDS,charindex(';',@cSourceGUIDS,1)-1)

??????????????????????? if(@cGUID <> '')
????????????????????????? begin
???????set @sql = N'set @iStatus=(select '+@newIStatus+' from '+@tableName+' where cGUID='+''''+@cGUID+''''+')'
???????print @sql
???????exec sp_executesql @sql,N'@iStatus int output',@iStatus output
??????????????????????????? begin
??????????????????????????? if(@iStatus is null)
??????????????????????????????? set @iStatus = -1
????????????????????????????? end
???????set @data=@data+@cGUID+','+cast(@iStatus as varchar(12))+';'
??????????????????????? end
??????????????????????? set?? @cSourceGUIDS=stuff(@cSourceGUIDS,1,charindex(';',@cSourceGUIDS,1),'')??
?print @data
end??
?--print @data
?----调用
execute? getCheckTableData 'cm_material','iStatus','003guid;00sguid',data