请教下,该怎样把下面的GUID传过去啊! 找不到好的方法?begin
select * from SpecificationProudct where [Guid] in (@SpecificationGuids)
end
exec Pro_dbo_SpecificationDetailsGetByDetails '20B9E371-98E0-414C-97CC-3BD5B4F20D4D,3CF53F72-C821-42F9-A8B4-463FECA4CB49','D26B83C6-6D1F-46D7-A4E8-CDECEA5842C7,E66E0A99-D989-44CB-9F3D-063F9833954'
select * from SpecificationProudct where [Guid] in (@SpecificationGuids)
end
exec Pro_dbo_SpecificationDetailsGetByDetails '20B9E371-98E0-414C-97CC-3BD5B4F20D4D,3CF53F72-C821-42F9-A8B4-463FECA4CB49','D26B83C6-6D1F-46D7-A4E8-CDECEA5842C7,E66E0A99-D989-44CB-9F3D-063F9833954'
declare @sql varchar(1000)
set @sql = '...in ('''+repalce(@SpecificationGuids ,',','','')
exec (@sql)
end
exec ('select * from SpecificationProudct where [Guid] in ('+@SpecificationGuids+')')
end
@SpecificationGuids VARCHAR(8000)
AS
BEGIN
DECLARE @sql VARCHAR(8000)
SET @sql = 'SELECT * FROM SpecificationProudct WHERE [Guid] IN ('+@SpecificationGuids+')'
EXEC (@sql)
ENDEXEC Pro_dbo_SpecificationDetailsGetByDetails
'20B9E371-98E0-414C-97CC-3BD5B4F20D4D,3CF53F72-C821-42F9-A8B4-463FECA4CB49,D26B83C6-6D1F-46D7-A4E8-CDECEA5842C7,E66E0A99-D989-44CB-9F3D-063F9833954'