Home Dashboard Directory Help
Search

SSMS - Cannot cast/convert to BIGINT in view designer by KorsG


Status: 

Closed
 as Won't Fix Help for as Won't Fix


1
0
Sign in
to vote
Type: Bug
ID: 693013
Opened: 10/4/2011 6:54:47 AM
Access Restriction: Public
0
Workaround(s)
view
1
User(s) can reproduce this bug

Description

When creating a view using the query designer, and you CAST/CONVERT a value to BIGINT, and execute the SQL in the designer - it will fail with the following error message:
--------------
SQL Execution Error.
Executed SQL statement: SELECT CAST(value AS bigint).ToString() FROM ....
Error Source: .Net SqlClient Data Provider
Error Message: Cannot call methods on bigint.
--------------
Im wondering why SSMS is doing ".ToString()" ?

But it's possible to save the view, and then select from it normally without the error message popping up.
Details
Sign in to post a comment.
Posted by Microsoft on 4/17/2012 at 10:35 AM
Hi Korsg,

Thanks for reporting this issue. We investigated the bug on our side, but since you can workaround the issue by saving the view, this doesn't meet the bar to fix.

Thanks again for taking the time to pass this bug on to us.

-Janet Yeilding
janety at microsoft dot com
Sign in to post a workaround.
File Name Submitted By Submitted On File Size  
SSMSCASTBIGINT.png 10/4/2011 83 KB