Specifying a Default Value for Stored Procedure Parameter
CREATE TABLE t_check ( id int identity( 1, 1) , name varchar (255) , filter_id int )
ALTER TABLE t_check ADD CONSTRAINT pk_t_check PRIMARY KEY (id)
INSERT INTO t_check( name , filter_id ) VALUES('Stefan' , 1 )
INSERT INTO t_check( name , filter_id ) VALUES('George' , 2 )
INSERT INTO t_check( name , filter_id ) VALUES('Peter' , 3 )
INSERT INTO t_check( name , filter_id ) VALUES('John' , 1 )
CREATE PROC gp_check @filter int = 0
as
if @filter = 0
SELECT * FROM t_check
else
SELECT * FROM t_check WHERE filter_id = @filter
EXEC gp_check
EXEC gp_check 1
ALTER TABLE t_check ADD CONSTRAINT pk_t_check PRIMARY KEY (id)
INSERT INTO t_check( name , filter_id ) VALUES('Stefan' , 1 )
INSERT INTO t_check( name , filter_id ) VALUES('George' , 2 )
INSERT INTO t_check( name , filter_id ) VALUES('Peter' , 3 )
INSERT INTO t_check( name , filter_id ) VALUES('John' , 1 )
CREATE PROC gp_check @filter int = 0
as
if @filter = 0
SELECT * FROM t_check
else
SELECT * FROM t_check WHERE filter_id = @filter
EXEC gp_check
EXEC gp_check 1
Comments
Write the first comment
Leave a trace
Post being viewed right now
