What is the difference between exporting to MS SQL Server and MS SQL Server (enhanced)?
MS SQL Server - Exports the dataset or session log in a structured query language file that can be read by SQL database programs. Columns in the export are named with the field name and a sequential number.
MS SQL Server (enhanced) - Like the MS SQL Server format, this exports the dataset or session log in a structured query language file that can be read by SQL database programs. Only duplicate column names have a sequential number appended to the field name.
The only difference is how appended data is exported and matched in the column names from the query to the table. For example, if a query contains fields A, B, and C and is exported to MS SQL Server, it will export into columns A, B, and C in that order. The table must have the columns in the same order for the data to be exported correctly. But if a query has fields B, C, and A, and the columns in the table are A, B, and C, MS SQL Server (enhanced) will match the fields in the query to the columns in the table so the exported data goes into the correct place.
This is machine translated content
Login to Subscribe
Please login to set up your subscription.
Didn't find the article you were looking for? Try these resources.