business-86-101-185-173.business.broadband.hu/business-86-101-185-173.business.broadband.hu.zip/business-86-101-185-173.business.broadband.hu/SensorProject.ZIP/StoreTemperatureData.sql

Text File | 2010-10-27 | 303b | 18 lines

SET ANSI_NULLS OFF
GO

SET QUOTED_IDENTIFIER ON
GO

CREATE PROCEDURE [dbo].[StoreTemperatureData]
@password varchar(17),
@value float,
@sensorid varchar(53)
AS
IF @password='xPMp%${,.22' BEGIN
    INSERT INTO TinyTSG.dbo.SensorData ( value, sensorid ) VALUES( @value, @sensorid )
END

GO