22,209
社区成员
发帖
与我相关
我的任务
分享
CREATE PROCEDURE Pro_dbo_SpecificationDetailsGetByDetails
@SpecificationGuids VARCHAR(8000)
AS
BEGIN
DECLARE @sql VARCHAR(8000)
SET @sql = 'SELECT * FROM SpecificationProudct WHERE [Guid] IN ('+@SpecificationGuids+')'
EXEC (@sql)
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'
begin
select * from SpecificationProudct where charindex(','+[Guid]+',',','+@SpecificationGuids+',')>0
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'
begin
exec ('select * from SpecificationProudct where [Guid] in ('+@SpecificationGuids+')')
end