I have a parameter for stored procedure, which I want to make optional and assign default value from a table, how do I do this? 

```
ALTER PROCEDURE [DBO].[Test]

      @planId int = 1  ( This I can do )

```

But I would like to do

```
@planId int = ( Select Id from Table1 Where name = ‘ABC’) ‘ Assign default id from a table

```