Description of the default values of mssql Stored Procedures and function parameters (1/4)

For mssql, the default value of function parameters indicates that createprocp (@ svarchar (1) a) asselect @ sgoexecpgo -- 1 alterprocp (@ sdecimala) as & nbsp; select @ sgoexecpgo * server: Message 8114, level 16, status 5, process p, line 0 description of mssql and default function parameters
Create our general statement

Create proc p (@ s varchar (1) = 'A ')

As

Select @ s

Go

Exec p

Go
-- 1
Alter proc p (@ s decimal =)
As
Select @ s
Go
Exec p
Go
/*

Server: Message 8114, level 16, status 5, process p, row 0
An error occurred while converting nvarchar to numeric.

*/

-- 2
Alter proc p (@ s varchar (1) = medium)
As
Select @ s
Go
Exec p
Go
/*

----

(The number of affected rows is 1)