INSERT INTO O_F_PROCESS
(OID, NEEDTIME, CARI, CARJ, STREET, AREA1, AREA2, SHOWI, SHOWJ, ARRIVED)
SELECT O_F_SAVE.OID, O_F_SAVE.NEEDTIME, COORDINATE.CARI, COORDINATE.CARJ,
COORDINATE.STREET, 0, 0, O_F_SAVE.SHOWI, O_F_SAVE.SHOWJ, 0
FROM O_F_SAVE JOIN
COORDINATE ON O_F_SAVE.SHOWI = COORDINATE.SHOWI
WHERE O_F_SAVE.SHOWJ = COORDINATE.SHOWJ AND ATEDIFF(MINUTE, '2000-9-5 10-2-32',
NEEDTIME) BETWEEN 30 AND 1410
(OID, NEEDTIME, CARI, CARJ, STREET, AREA1, AREA2, SHOWI, SHOWJ, ARRIVED)
SELECT O_F_SAVE.OID, O_F_SAVE.NEEDTIME, COORDINATE.CARI, COORDINATE.CARJ,
COORDINATE.STREET, 0, 0, O_F_SAVE.SHOWI, O_F_SAVE.SHOWJ, 0
FROM O_F_SAVE JOIN
COORDINATE ON O_F_SAVE.SHOWI = COORDINATE.SHOWI
WHERE O_F_SAVE.SHOWJ = COORDINATE.SHOWJ AND ATEDIFF(MINUTE, '2000-9-5 10-2-32',
NEEDTIME) BETWEEN 30 AND 1410
解决方案 »
- 存储过程往外抛error
- 仍然是语句问题,迷糊.
- 求一sql语句
- 随vs2005安装的sql server2005怎样配置 怎样登录?
- 关于sql2000中float数据类型的问题!
- 能同时安装MSSQL2000和2005么?
- 定义一个局部变量@SQL varchar(90),set @SQL = 'declare @s nvarchar(100)' + char(13),后面的+ char(13)有什么用啊,请高手帮忙阿,
- sql存储结构的问题和自动编号字段的设置问题请教大家
- 请教SQL关于借出还入单的问题,请大家帮帮忙
- sql:计算工作日
- 请教 大力 同志及各位高手
- 怎样提高SQL书写能力,给分
(OID, NEEDTIME, CARI, CARJ, STREET, AREA1, AREA2, SHOWI, SHOWJ, ARRIVED)
SELECT O_F_SAVE.OID, O_F_SAVE.NEEDTIME, COORDINATE.CARI, COORDINATE.CARJ,
COORDINATE.STREET, 0, 0, O_F_SAVE.SHOWI, O_F_SAVE.SHOWJ, 0
FROM O_F_SAVE ,
COORDINATE
WHERE O_F_SAVE.SHOWI = COORDINATE.SHOWI AND
O_F_SAVE.SHOWJ = COORDINATE.SHOWJ AND DATEDIFF(MINUTE, '2000-9-5 10-2-32',
NEEDTIME) BETWEEN 30 AND 1410