Node.js中的SQL Server:查询可在服务器上运行,但不能通过Node.js驱动程序
以下查询是由脚本生成的,插入到我们的SQL Server中,然后登录到控制台。
字段是匿名的:
INSERT INTO
T_OUTLOOK_Kalendereintrag (
field1,
field2,
field3,
fieldN,
fieldN,
fieldN,
fieldN,
fieldN,
fieldN,
fieldN,
fieldN,
fieldN,
fieldN,
fieldN,
fieldN,
fieldN,
fieldN,
fieldN,
fieldN,
fieldN,
fieldN,
fieldN,
fieldN,
fieldN,
fieldN,
fieldN,
fieldN,
[fieldN WithSpace],
[fieldN WithSpace],
[fieldN WithSpace],
[fieldN WithSpace],
[fieldN WithSpace],
[fieldN WithSpace],
[fieldN WithSpace],
[fieldN WithSpace],
[fieldN WithSpace],
fieldN,
fieldN,
fieldN,
fieldN,
fieldN,
fieldN,
fieldN,
fieldN
)
VALUES
(
'a2714a8c-3718-42db-87b5-e5c570f84151',
null,
'1355',
'06.08.2019 00:00:00',
'201908',
'06.08.2019 12:58:00',
'06.08.2019 18:58:00',
6,
'Comment field',
'test',
'0900',
'0900',
null,
null,
0.75,
6,
0,
'PT',
'R4200',
0,
0,
null,
null,
0,
0,
'',
0,
'Jane Doe',
'20.09.2019 11:03:41',
'20.09.2019 11:03:41',
null,
null,
null,
'Jane Doe',
null,
null,
null,
1,
1,
'1',
'1',
'20.09.2019 11:03:41',
'20.09.2019 11:03:41',
0
)
通过以下代码插入服务器时
try {
await sql.connect(`mssql://${config.get('config.dbConfig.user')}:${config.get('config.dbConfig.pw')}@${config.get('config.dbConfig.server')}/${config.get('config.dbConfig.dbTest')}`);
result = await sql.query(sqlQuery);
sql.close();
} catch (e) {
sql.close();
logger.error(e);
console.log(e);
}
我收到以下错误:
{ number: 242,
state: 3,
class: 16,
message:
'The conversion of a varchar data type to a datetime data type resulted in an out-of-range value.',
serverName: 'hostname',
procName: '',
lineNumber: 1,
name: 'ERROR',
event: 'errorMessage' } },
但是,当进行上述查询并直接通过HeidiSQL查询时,一切正常吗?有任何想法吗?我找不到错误,也找不到该错误。
回答如下: