stored procedure string parameter accepts default value without quotes - by Saeid Hasani

Status : 

  Won't Fix<br /><br />
		Due to several factors the product team decided to focus its efforts on other items.<br /><br />
		A more detailed explanation for the resolution of this particular item may have been provided in the comments section.

Sign in
to vote
ID 987259 Comments
Status Closed Workarounds
Type Bug Repros 0
Opened 9/30/2014 2:58:57 PM
Access Restriction Public


We can define a parameter with string data type such as NVARCHAR which accepts default value without quotes.
Sign in to post a comment.
Posted by Saeid Hasani on 10/4/2014 at 2:16 AM
Thanks Jos de Bruijn!
Hope it will be fixed one day!

Saeid Hasani
Posted by Microsoft on 10/2/2014 at 3:20 PM
Thanks for submitting this feedback.

While I agree that this behavior is not optimal, it has been in the product for a long time. Therefore, we cannot easily change it, as it would break existing apps.

Jos de Bruijn - SQL Server PM