Run Code
|
API
|
Code Wall
|
Misc
|
Feedback
|
Login
|
Theme
|
Privacy
|
Patreon
Null as default value
--Batches are separated by 'go' CREATE PROCEDURE [dbo].[Test_Default_Null] @Name nvarchar(1000) = null AS BEGIN select @Name END GO CREATE PROCEDURE [dbo].[Test_No_Default] @Name nvarchar(1000) AS BEGIN select @Name END GO exec Test_Default_Null 'Hello' exec Test_Default_Null null exec Test_Default_Null exec Test_No_Default 'Hello' exec Test_No_Default null exec Test_No_Default --expects parameter
run
|
edit
|
history
|
help
0
New
Demo
ERROR
Names
how-to-assign-a-random-value-in-a-select-statement-in-sqlserver
Loading json file into sql server
c12part2
Tablestudent
MSSQL NVARCHAR to INT conversions
TSQL - Unique string generator