MS SQL CrashBug

[expired user #9613]'s profile image [expired user #9613] posted 8 years ago in General Permalink

I cannot select a custom column from our MS SQL Server Below is the details

Custom Column in SQL Studio: http://i.imgur.com/eGlngWT.png

Custom Column in HeidiSQL Portable 9.3.0.5049: http://i.imgur.com/Bnb8bsQ.png

SQL Sever 12.0.4213.0

1 attachment(s):
[expired user #9613]'s profile image [expired user #9613] posted 8 years ago Permalink

Anyone look into this?

ansgar's profile image ansgar posted 8 years ago Permalink

HeidiSQL cannot handle custom columns, and I also never heard of that until now. Is that a custom data type or?

[expired user #9613]'s profile image [expired user #9613] posted 8 years ago Permalink

It could be, but its really just a 36 digit int/decimal I'm more than willing to help you fix this issue by providing testing for anything. I believe my original post included everything you would need.

ansgar's profile image ansgar posted 8 years ago Permalink

The error message is

Multiple-step operation generated errors. Check each status value

and its deep in the underlying ADODB units.

You should post some SQL here for reproducing the issue.

[expired user #9613]'s profile image [expired user #9613] posted 8 years ago Permalink

What type of SQL do you need? a DDL for the table? Hopefully gets you what you need, first bit creates the function for the custom datatype then the 2nd is a random table with the ReferenceKey column

http://pastebin.com/JqWvnLA7

ansgar's profile image ansgar posted 8 years ago Permalink

Can you cast that ReferenceKey column as decimal when selecting?

I found some random answers to the error message here:

[expired user #9613]'s profile image [expired user #9613] posted 8 years ago Permalink

I could sure, but that would be annoying and bothersome having to do that everytime. For instance Sometimes i just need to check data quick with a SELECT *

I'm just trying to help improve your program and fix bugs. Not really looking for a workaround.

Please login to leave a reply, or register at first.