View Designer and datatype abbreviations - by mxrdr21

Status : 


Sign in
to vote
ID 777746 Comments
Status Closed Workarounds
Type Bug Repros 0
Opened 1/29/2013 4:06:23 AM
Access Restriction Public


View designer will error with "Can Not Call Methods On [datatype]" when creating a view that includes CAST() with an abbreviated datatype i.e. Dec for Decimal or Int for Integer, this has been noted with previous versions of SSMS and I just ran into it with 2012 Standard SP1. It is easily gotten around by using the full datatype however.
Sign in to post a comment.
Posted by Sanjay [MSFT] on 2/6/2013 at 12:01 PM
Hi!, thanks for writing in to Microsoft and reporting this bug.

We took a look at this bug and triaged it against several others and unfortunately, it did not meet the bar to be fixed. While we are closing this bug as 'won't fix', we have taken note of this internally and we will try & incorporate this request when we revisit this functionality in a future release of SSMS.

Sanjay Nagamangalam, SQL Server Manageability