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

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.

Sign in
to vote
ID 693013 Comments
Status Closed Workarounds
Type Bug Repros 1
Opened 10/4/2011 6:54:47 AM
Access Restriction Public


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. 
Sign in to post a comment.
Posted by Janet [MSFT] 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