Home > database >  Navicat15 MSSQL export table, it can't import into. What reason? Want to how to operate to impo
Navicat15 MSSQL export table, it can't import into. What reason? Want to how to operate to impo

Time:03-08

The CREATE TABLE [dbo] [table_name] (
Ufts timestamp NOT NULL,
Then insert the use
Insert INTO [dbo] [table_name] ([ufts],,,,,) values (0 x0000000001b34e9c, N '8171', N '1000000001')
Import an error:
"Explicit values can not be inserted into the timestamp column, please use the column list INSERT to exclude timestamp columns, or INSERT DEFAULT timestamp columns,"

0 x0000000001b34e9c I convert into DEFAULT, you can import and went in, but this after all, who has a good export way? Can guarantee after export, can be imported into,
My navicat11, export to is the DEFAULT, 15 what changed?
  • Related