Tag Archives: T-SQL

Stored Procedure string parameter accepts default value without quotes

Supposing that we define a parameter with string data type such as NVARCHAR. We can assign a default value for this parameter usually using quotes. So, the following code must encounter an error: CREATE PROC uspStringWithoutQuotes   @Param NVARCHAR(20) = Hello … Continue reading

Posted in T-SQL Tips & Tricks | Tagged , ,