我需要在存储过程中进行多个选择查询 [英] i need multiple select query in stored procedure

问题描述

这是我的存储过程：

this is my stored procedure:

ALTER PROCEDURE [dbo].[cls_search]
	@serarchtype int=null,   // this mode use for multiple select
	@cls_code varchar(20)=null,// other twoo are column
	@cls_name varchar(30)=null
AS
BEGIN
		if (@serarchtype = 1)
		BEGIN
		select cls_code,cls_name from Cls_master where cls_code=@cls_code 
		END
		else
		BEGIN
		select cls_code,cls_name from Cls_master where cls_name=@cls_name 
		END
END

i希望使用1作为@serarchtype和@cls_code但是没有给@cls_name然后首先选择查询

执行





否则

使用2作为@serarchtype和@cls_name但不给@cls_code然后第二个选择查询执行







plz帮帮我

i want to use 1 as @serarchtype and @cls_code but no give @cls_name then first select query
execute


otherwise
use 2 as @serarchtype and @cls_name but no give @cls_code then second select query execute



plz help me

推荐答案

嗯，对于初学者来说，这个修改离子有效：

Well, for starters, this modification works:

DECLARE @strNonsense_02 [nvarchar](66)
SET @strNonsense_02 = 'nonesense_02'
DECLARE @searchtype[int]
SET @searchtype = 1
BEGIN
		if (@searchtype = 1)
		BEGIN
		select @strNonsense_01 --cls_code,cls_name from Cls_master where cls_code=@cls_code 
		END
		else
		BEGIN
		select @strNonsense_02 -- from Cls_master where cls_name=@cls_name 
		END
END

退货：

Returns:

nonesense_01

和：

And:

BEGIN
		if (@searchtype = 65)
		BEGIN
		select @strNonsense_01 --cls_code,cls_name from Cls_master where cls_code=@cls_code 
		END
		else
		BEGIN
		select @strNonsense_02 -- from Cls_master where cls_name=@cls_name 
		END
END

返回：

Returns:

nonsense_02

对数据不了解，这就是我可以冒险解决的问题...

Not privy to the data, that's all I can venture from the description of the problem ...

这篇关于我需要在存储过程中进行多个选择查询的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！