Handling Unsupported Data Types in SQL Queries with External Database Connector

0
I am currently familiarizing myself with the external database connector. My source database has, for example, a tinyint in various tables. When I run an SQL query, I do receive the response data, but when I try to use 'Use Response', I get the error: Data type 'tinyint' is not supported.   I have already tried casting/converting the relevant columns to int in the query, but I still get the same error.   Is there a way to change unsupported data types in the query so that I can use them (without creating a stored procedure for each query)?
asked
1 answers
1

Hello Florian Ziegler,

 

May this helpful! Check here the syntax missing or not

 

Error casting tiny int

 

convert column type from tinyint to int in sql-server

 

OR

 

You can alter the column in sql and not lose data:

 

alter table MyTable alter column MyColumn tinyint --(null|not null)
answered