State Machine Complier And Asp.net

��USE [CarAutomation]

GO

/****** Object:  StoredProcedure [dbo].[isp_StateAuditLog]    Script Date: 10/20/2008 18:55:17 ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

CREATE PROCEDURE [dbo].[isp_StateAuditLog]  

 -- Add the parameters for the stored procedure here  

	@Car_ID NVARCHAR(20),  

    @Updated_By INT,  

    @Current_State_ID INT,  

    @Remarks VARCHAR(max)  

AS  

INSERT INTO [CarAutomation].[dbo].[StateAuditLog]

           ([Car_ID]

           ,[State_ID]

           ,[Remarks]

           ,[Created_By]

           ,[Created_Date]

           ,[Last_Updated_By]

           ,[Last_Updated_Date])

     VALUES

           (@Car_ID

           ,@Current_State_ID

           ,@Remarks

           ,@Updated_By

           ,GetDate()

           ,@Updated_By

           ,GetDate())