下面这一存储过程错在哪里?
CREATE PROCEDURE dbo.TempDataSave
@prodmod varchar(50),
@time datetime,
@count int,
@value1 float(8),
@value2 float(8),
AS
insert into TTempChart(tempchart_chartnum,tempchart_prodmod,tempchart_time,tempchart_count,tempchart_value) values
(1,@prodmod,@time,@count,@value1)
insert into TTempChart(tempchart_chartnum,tempchart_prodmod,tempchart_time,tempchart_count,tempchart_value) values
(2,@prodmod,@time,@count,@value2)
GO
服务器: 消息 156,级别 15,状态 1,过程 TempDataSave,行 7
在关键字 'AS ' 附近有语法错误。
------解决方案--------------------CREATE PROCEDURE dbo.TempDataSave
@prodmod varchar(50),
@time datetime,
@count int,
@value1 float(8),
@value2 float(8), --去掉,
AS