CREATE proc yl_StockGSC111@storeCode nvarchar(500)
as
exec('select MDate,StoreCode,GoodsCode,Color,DetailedSize from MainStore
where StoreCode in ('+@storeCode+')')
GO
as
exec('select MDate,StoreCode,GoodsCode,Color,DetailedSize from MainStore
where StoreCode in ('+@storeCode+')')
GO
解决方案 »
- 求一个供需查询问题,具体描述讲不清楚,请看具体内容吧
- 联合索引疑问
- 一分钟之内将数据插入对应的5万张表,该如何建表建存储过程呢
- 求一条HQL或者SQL,求count和sum
- 索引的问题,如果有三个字段: a,b,c 需要几种排序方式:a/b/c a/c/b b/a/c b/c/a c/a/b c/b/a,那么是否一定要建这么多的索引?
- SQL数据库恢复:这个问题你能解决吗?
- 请问在SQL2000中怎样获得某个表的某个字段的id(即smallid)
- 请问IS NULL 和 = NULL 有什么区别?
- 火线求助各位大侠,在线等待回答!!!!!
- 请问在那里可以下载到Oracle 7.2,非常感谢!!!!
- 存储过程中的参数需要支持多选,有没有简便的办法?
- 各位高手帮帮忙 特急!!!!!!!!!
exec yl_StockGSC111 '''001'',''002'''
Have a try like this:CREATE proc yl_StockGSC111@storeCode nvarchar(500)
as
exec('select MDate,StoreCode,GoodsCode,Color,DetailedSize from MainStore
where StoreCode in ('''+@storeCode+''')'
GO
@storeCode nvarchar(500)
as
select MDate,StoreCode,GoodsCode,Color,DetailedSize from MainStore
where charindex(',' + StoreCode + ',',',' + @storeCode + ',') > 0
GO如果是数字,则:
where charindex(',' + cast(StoreCode as varchar) + ',',',' + @storeCode + ',') > 0
1、参数是'001,002'的格式:
declare @storeCode nvarchar(500)
set @storeCode = '001,002'
print 'select MDate,StoreCode,GoodsCode,Color,DetailedSize from MainStore
where StoreCode in ('''+ replace(@storeCode,',',''',''') +''')'2、参数是''001','002''的格式:
declare @storeCode nvarchar(500)
set @storeCode = '''001'',''002'''
print 'select MDate,StoreCode,GoodsCode,Color,DetailedSize from MainStore
where StoreCode in ('+ @storeCode +')'
gmlxf(烛光) ,我用你的charindex方法可以,能否给我解释一下其中的参数的意思,谢谢!