ALTER PROCEDURE dbo.sp_NAWAT_MISC_SpotfireInternalQC
(@state_name nvarchar(255) = NULL,
@play_name nvarchar(255) = NULL
)
AS
BEGIN
---- your code
WHERE (state_name = @state_name OR state_name is null)
AND (play_name = @play_name OR play_name is null) ;
END
GO
or
(reference:SQL - Passing multiple values through one parameter in a stored procedure)
AS
BEGIN
SET @Sql = '
---- your code
No comments:
Post a Comment