更新时间:2022-11-22 23:00:45
使用运算符代替
CONVERT(varchar,cbm_batch_start_dt,101)> = CONVERT(varchar,StartDate,101)和CONVERT(varchar,cbm_batch_end_dt,101)< = CONVERT(varchar,EndDate,101)
Use Operators instead of between
CONVERT(varchar,cbm_batch_start_dt,101)> = CONVERT(varchar,StartDate,101) and CONVERT(varchar,cbm_batch_end_dt ,101) <= CONVERT(varchar,EndDate,101)
尝试以下方法添加参数 -
配置参数和参数数据类型 [ ^ ]
如何使用参数创建SQL Server存储过程 [ ^ ]
http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=159448 [ ^ ]
Try the following for adding parameters -
Configuring Parameters and Parameter Data Types[^]
How to create a SQL Server stored procedure with parameters [^]
http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=159448[^]