CREATE PROCEDURE dbo.TEST15
@SETTLE_DATE DATETIME
AS
DELETE FROM T_LCCRPT_ENTRY_SJT WHERE SETTLE_DATE = @SETTLE_DATE AND--------------怎么总是提示insert 附近有语法错误啊INSERT INTO T_LCCRPT_ENTRY_SJT SELECT STATION_CODE,'03' AS LINE_NO, CONVERT(DATE,COLLECT_DATE) AS SETTLE_DATE ,ISNULL(COUNT(*) ,0) AS SJT_CNT
FROM lcc.dbo.T_TRAN_ENTRAY_TRADE
WHERE CONVERT(DATE,COLLECT_DATE) = @SETTLE_DATE
GROUP BY CONVERT(DATE,COLLECT_DATE),STATION_CODE
-------------------------------------------------------下面是错误提示:
Server Message: Number 156, Severity 15
Server 'AFCSERVER1', Procedure 'dbo.TEST15', Line 11:
Incorrect syntax near the keyword 'INSERT'.
@SETTLE_DATE DATETIME
AS
DELETE FROM T_LCCRPT_ENTRY_SJT WHERE SETTLE_DATE = @SETTLE_DATE AND--------------怎么总是提示insert 附近有语法错误啊INSERT INTO T_LCCRPT_ENTRY_SJT SELECT STATION_CODE,'03' AS LINE_NO, CONVERT(DATE,COLLECT_DATE) AS SETTLE_DATE ,ISNULL(COUNT(*) ,0) AS SJT_CNT
FROM lcc.dbo.T_TRAN_ENTRAY_TRADE
WHERE CONVERT(DATE,COLLECT_DATE) = @SETTLE_DATE
GROUP BY CONVERT(DATE,COLLECT_DATE),STATION_CODE
-------------------------------------------------------下面是错误提示:
Server Message: Number 156, Severity 15
Server 'AFCSERVER1', Procedure 'dbo.TEST15', Line 11:
Incorrect syntax near the keyword 'INSERT'.
...这里后面的要和前面那名连一起吗?
insert into 是不能返回的
显然 楼主,着个地方正错了,你要插入某一个的东西,那你先得到那一天你想要的东西,然后把一项一项的值在插入进去,
或者你也可以把一个表复制到另外一个表里边,做外另外一个表的内容,着个不知道怎么写,但是确实是有这样的写法