--截取字符串
declare @sql varchar(8000),@i int,@str varchar(200)
select @sql='',@i=1,@str='001002003004' -------输入字符串
while @i<len(@str)
begin
select @sql=@sql+' union all select '''+substring(@str,@i,3)+'''as ID', @i=@i+3
end
set @sql=stuff(@sql,1,len(' union all '),'')
//////////////////////////////////////////////////////////
--查询存储过程
@ID char(3)
ASSELECT SD_BookID, SD_Publisher, SD_StockNum, SD_BookAuthor, SD_Type, SD_ImageFile, SD_BooksName, SD_ContentIntroduce, SD_Catalog,
SD_AuthorSynopsis, SD_MartPrice, SD_RebatePrice
FROM CE_SD_Books
WHERE SD_BookID = @ID
declare @sql varchar(8000),@i int,@str varchar(200)
select @sql='',@i=1,@str='001002003004' -------输入字符串
while @i<len(@str)
begin
select @sql=@sql+' union all select '''+substring(@str,@i,3)+'''as ID', @i=@i+3
end
set @sql=stuff(@sql,1,len(' union all '),'')
//////////////////////////////////////////////////////////
--查询存储过程
@ID char(3)
ASSELECT SD_BookID, SD_Publisher, SD_StockNum, SD_BookAuthor, SD_Type, SD_ImageFile, SD_BooksName, SD_ContentIntroduce, SD_Catalog,
SD_AuthorSynopsis, SD_MartPrice, SD_RebatePrice
FROM CE_SD_Books
WHERE SD_BookID = @ID
调用
select *,dbo.fu_xxx(参数) from 表