DP44/DataPRO/Modules/Database/DatabaseMigrationScripts/.svn/pristine/58/581ff1c9081902bc4214984025ef92b2837345ef.svn-base

<EFBFBD><EFBFBD>CREATE PROCEDURE [dbo].[sp_SensorsChangeHistoryInsert]
	@SensorId                                   INT,
	@ChangeType                                 INT,
	@Timestamp                                  DateTime,
	@Username                                   NVARCHAR(MAX),
	@Value1                                     NVARCHAR(MAX),
	@Value2                                     NVARCHAR(MAX),
	@Value3                                     NVARCHAR(MAX),
	@Value4                                     NVARCHAR(MAX),
	@errorNumber								INT OUTPUT,
	@errorMessage								NVARCHAR (255) OUTPUT,
	@new_id										INT OUTPUT
AS
BEGIN
	SET NOCOUNT ON
	SET @errorNumber = 0
	SET @errorMessage = ''	

	INSERT INTO [dbo].[SensorChangeHistory] (
	[SensorId],
	[ChangeType],
	[UserName],
	[Timestamp],
	[Value1],
	[Value2],
	[Value3],
	[Value4]	
	)
	VALUES (
	@SensorId,
	@ChangeType,
	@UserName,
	@Timestamp,
	@Value1,
	@Value2,
	@Value3,
	@Value4
	)

	SELECT @new_id = SCOPE_IDENTITY()
	if(@@error != 0)
	begin
		set @errorNumber = error_number()
		set @errorMessage = error_message()
	end
	SET @new_id = @SensorId
END