When importing data into a table in SQL, what is the duplicate table name with the Suffix "$"
So I exported two tables in their entirety out of S开发者_开发技巧QL (2005) into an excel file. During the import wizard to import the tables, on the screen presenting the tables to import it showed 4 tables.
Two which were duplicate names with the small difference of having the suffix "$" on the end. I chose to import all 4 and it went through.
Are the tables with the "$" suffix metadata or some other information?
The $ is what you see when you are working with Worksheets in Excel. If you want to import into the same table, get rid of the automagic naming and import into the table itself.
Want proof? Export tables to an Excel spreadsheet. Reimport without removing the $. Compare data between the tables. You will not have all of your constraints on the "$" tables and the data types might be off, but the data will be identical.
精彩评论