Home >Database >Mysql Tutorial >In SAP database, import table columns with / in the name
In SAP database, import table columns with / in the name
- WBOYforward
- 2023-09-04 12:05:011211browse
I recommend that you use the BCP utility to import/export data to a text file in SQL Server. When you run the following command, it loads the data into a text file.
BCP Db.TN out "Location of the text file " -c -S ServerName –T
Now, if you want to load data from a flat file into SQL Server, you can use the following command:
BCP Db.TN in "Location of the text file " -c -S ServerName –T
You can also try to edit the mapping while loading the data from the flat file.
The above is the detailed content of In SAP database, import table columns with / in the name. For more information, please follow other related articles on the PHP Chinese website!
Statement：
This article is reproduced at:tutorialspoint.com. If there is any infringement, please contact admin@php.cn delete
Previous article：How can we use MySQL INSTR() function with WHERE clause?Next article：How can we use MySQL INSTR() function with WHERE clause?