(ERR) 1 & gt; INSERT INTO [dbo] [ABC] VALUES (N '1'?
(ERR) 1 & gt; 17 [HY104] [Microsoft] [ODBC Driver for SQL Server] the precision of the invalid value (0)
I am using navicat software
The above is my local test between two database error again, specific operation procedure is: casual photo first stored in SQL server database, then use to MySQL navicat transmission, success; The SQL server database table data delete, before the data transmission of the transmission to MySQL to the SQL server, failure, error shown above,
Purpose: the company to do the data backup, data acquisition and now stored in a MySQL database, now I need to backup to the local SQL server database,
(ERR) 1 & gt; INSERT INTO [dbo] [curveresults] VALUES (N '1'? , (N '2'? , (N '3'? , (N '4'? , (N '5'? , (N '6'? , (N '7'? , (N '8',?) , (N '9',?) , (N '10'? , (N '11',?) , (N '12'? , N '13'? , N '14'? , (N '15'? , (N '16'? , (N '17'? , N '18'? , N '19'? , (N '20',?) , (N '21'? , (N '22'? , (N '23'? , (N '24'? , (N '25',?) , (N '26'? , (N '27',?) , N '28'? , (N '29',?) , (N '30'? , N '31'? , (N '32',?) , (N '33',?) , (N '34',?) , (N '35'? , (N '36',? , N '37'? , (N '38',?) , (N '39'? , (N '40'? , N '41 "? , (N '42',?) , (N '43'? , (N '44'? , (N '45',?) , N '46'? , (N '47',?) , N ', 48 '? , N '49'? , (N '50'? , (N '51,?) , N '52'? , (N '53'? , (N '54',? , (N '55',?) , (N '56'? , N '57'? , (N '58'? , (N '59,?) , (N '60,?) , (N '61'? , (N '62'? , (N '63'? , (N '64'? , (N '65'? , (N '66'? , (N '67'? , (N '68'? , (N '69'? , (N '70'? , (N '71'? , (N '72'? , (N '73'? , (N '74'?
(ERR) 1 & gt; [HY104] [Microsoft] [10.0] SQL Server Native Client invalid precision value (0)
This is my fault in the actual operation times,
Because of the need to backup regularly, I realized that with navicat software timing task, have a big help me do something
.CodePudding user response:
Are interested to talk about personal