How do we pass default value as input parameter in a store procedure?

Priyanka Roy

• Dec 6th, 2017

DECLARE @Parameter1 varchar(max)=PRIYANKA

Code
DECLARE
@Parameter1 varchar(max)=PRIYANKA

nisargkothari

 Profile Answers by nisargkothari Questions by nisargkothari

• Sep 16th, 2010

Create procedure sp_test@param1 INT ,@param2 INT= valueas select * from testtable1 where value1 = @param1 and value2 = @param2

Answer Question  Select Best Answer