SP 傳了兩個參數進來,可以使用如下SQL處理非空
CREATE/ALTER Procedure [dbo].[sp_name](@param1 varchar(20),@param2 varchar(20))AS
SELECT
column_1, column_2
FROM
table_1
WHERE
( column_1 >= @param1 or isnull(@param1,'')='' ) and
( column_1 <= @param2 or isnull(@param2,'')='' )
GO
GO