Home Dashboard Directory Help
Search

View Designer and datatype abbreviations by mxrdr21


Status: 

Closed


1
0
Sign in
to vote
Type: Bug
ID: 777746
Opened: 1/29/2013 4:06:23 AM
Access Restriction: Public
0
Workaround(s)
view
0
User(s) can reproduce this bug

Description

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.
Details
Sign in to post a comment.
Posted by Microsoft 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.

Regards,
Sanjay Nagamangalam, SQL Server Manageability
Sign in to post a workaround.