About the MSSQL stored procedure, function parameter default value description (1/4)

About MSSQL stored procedures, function parameter default value description
To create our general writing

Create proc P (@s varchar (1) = ' a ')

As

Select @s

Go

EXEC p

Go
--1
ALTER PROC P (@s decimal=a)
As
Select @s
Go
EXEC p
Go
/*

Server: Message 8114, Level 16, State 5, process p, line 0
An error occurred while converting the data type nvarchar to numeric.

*/

--2
ALTER PROC P (@s varchar (1) = medium)
As
Select @s
Go
EXEC p
Go
/*

----

(The number of rows affected is 1 rows)

Home 1 2 3 4 last page