View Designer and datatype abbreviations by mxrdr21

Closed

Type:	Bug
ID:	777746
Opened:	1/29/2013 4:06:23 AM
Access Restriction:	Public

Workaround(s)

view

User(s) can reproduce this bug

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 (expand)

English

SQL Server 2012 SP1

Tools (SSMS, Agent, Profiler, Migration, etc.)

Other

US English

OS=Windows 8

Create a new View and use Cast(... as Dec(5,2)) in at least one column, and execute the query to preview the View.

Can Not Call Methods On Decimal"

View query execution

X64

Other (e.g. VM Ware, specify in Description)

0 attachments

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

Microsoft