X icon indicating copy to clipboard operation
X copied to clipboard

Published 20 hours ago • verified publisher icon NewLifeX

参数化开启后，sqlserver datetime字段可以为null的情况下，如果不给这个字段赋值，也会报错

Open christan-duplicate opened this issue 3 years ago • 2 comments

参数化开启后，sqlserver datetime字段可以为null的情况下，如果不给这个字段赋值，也会报错

XCode.Exceptions.XSqlException: 参数化查询 '(' 需要参数 '@FinishTime'，但未提供该参数。[SQL:SET NOCOUNT ON;Insert Into SatelliteWarehouse(AddTime,IsAvailable,IsFinish,FinishTime,RetryTime) Values(@AddTime,@IsAvailable,@IsFinish,@FinishTime,@RetryTime);Select SCOPE_IDENTITY() [@AddTime=2020-12-03 09:19:50, @IsAvailable=True, @IsFinish=False, @FinishTime=, @RetryTime=2020-12-03 10:35:09]][DB:Test/SqlServer]

christan-duplicate avatar Dec 03 '20 04:12 christan-duplicate

未能重现，可否有进一步的信息？

nnhy avatar Jan 20 '21 15:01 nnhy

插入逻辑在上个月有调整，可以试试

nnhy avatar May 01 '22 00:05 nnhy