34,594
社区成员
发帖
与我相关
我的任务
分享
IF @SecuCategoryDesc=0
BEGIN
SELECT @InnerCode=A.XX
FROM [TABLE] A
WHERE A.AA=@StockCode
AND charindex(CAST(A.BB AS VARCHAR(5)), @SecuCategory)>0
end
IF (@SecuCategoryDesc=0)
BEGIN
EXEC ('SELECT '+@InnerCode+'=A.XX FROM TABLE A WHERE A.AA='''+@StockCode+''' AND CAST(A.BB AS VARCHAR(5)) IN ('+@SecuCategory+')')
END
IF @SecuCategoryDesc=0
BEGIN
SELECT @InnerCode=A.XX
FROM TABLE A
WHERE A.AA=@StockCode AND charindex(CAST(A.BB AS VARCHAR(5)), @SecuCategory)>0