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

How do we call stored procedure dynamically?

suneesece

 Profile Answers by suneesece Questions by suneesece

• May 19th, 2010

We can call using dynamic SQL, Execute Immediate.

Answer Question  Select Best Answer

What is meant by Hash Code?