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.


3
1
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

Description

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 Jos [MSFT] 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