With a sql query I connected my business adapter to a database to list the users. and after that, I want to add a column in my result of the business adapter with the name of a license.
I test with "add column" but i have an error message.
First of all, "GO" is not a Transact-SQL statement, so you can't include that in your query text. ("GO" is a command used in interactive tools like SQL Server Management Studio to send batches of commands to SQL server.)
Secondly, you can only include a single "SELECT" statement in the adapter's query field to retrieve data to be imported. If you want to execute other direct SQL statements during the import process after to be imported data has been retrieved, you should add a custom object in your adapter
Thirdly, "ADD COLUMN" is not a Transact-SQL statement either. I suspect you are meaning to use the "ALTER TABLE" statement. For example:
ALTER TABLE #ECMImport_YourImportName
ADD COLUMN licensename NVARCHAR(256)
(Did my reply solve the question? Click "ACCEPT AS SOLUTION" to help others find answers faster. Liked something? Click "KUDO". Anything expressed here is my own view and not necessarily that of my employer, Flexera.)
First of all, "GO" is not a Transact-SQL statement, so you can't include that in your query text. ("GO" is a command used in interactive tools like SQL Server Management Studio to send batches of commands to SQL server.)
Secondly, you can only include a single "SELECT" statement in the adapter's query field to retrieve data to be imported. If you want to execute other direct SQL statements during the import process after to be imported data has been retrieved, you should add a custom object in your adapter
Thirdly, "ADD COLUMN" is not a Transact-SQL statement either. I suspect you are meaning to use the "ALTER TABLE" statement. For example:
ALTER TABLE #ECMImport_YourImportName
ADD COLUMN licensename NVARCHAR(256)
(Did my reply solve the question? Click "ACCEPT AS SOLUTION" to help others find answers faster. Liked something? Click "KUDO". Anything expressed here is my own view and not necessarily that of my employer, Flexera.)
