S
sajberek
Guest
optional parameter in stored procedure (MSSQL)
Hi. I've got a question about stored procedures.
I'd like to create a procedure with optional parameter. It means i'd like to do something like that:
CREATE PROCEDURE test
@id int,
@error int output
AS
blahblah
And now:
exec test @id, [@error - not nessesarely]
Is that possible in TSQL?
Hi. I've got a question about stored procedures.
I'd like to create a procedure with optional parameter. It means i'd like to do something like that:
CREATE PROCEDURE test
@id int,
@error int output
AS
blahblah
And now:
exec test @id, [@error - not nessesarely]
Is that possible in TSQL?