我用如下语句创建了存储过程:
CREATE PROCEDURE TONGJI AS
begin
select TankName,LineName,MacAddress,DateTime,DataIndex from monitordata
end
go
怎么用下面语句查询,出现错误:对象名 'tongji' 无效。
select * from tongji
请问这是什么回事呀?
CREATE PROCEDURE TONGJI AS
begin
select TankName,LineName,MacAddress,DateTime,DataIndex from monitordata
end
go
怎么用下面语句查询,出现错误:对象名 'tongji' 无效。
select * from tongji
请问这是什么回事呀?
exec tongji '参数1',....
DECLARE @dt datetime
begin
select TankName,LineName,MacAddress,[DateTime],DataIndex
from monitordata
where [DateTime] =@dt
end
go
exec tongji '2011-05-05 09:15:57'