CREATE PROCEDURE [dbo].expert

AS
BEGIN
	-- SET NOCOUNT ON added to prevent extra result sets from
	-- interfering with SELECT statements.
	SET NOCOUNT ON;

    -- Insert statements for procedure here
		CREATE TRIGGER [dbo].[Trig_InsUpd_Users]
			ON [dbo].[Users] 
			AFTER INSERT, UPDATE
		AS
		BEGIN
  			SET NOCOUNT ON;

			-- Insert statements for trigger here
			update dbo.Users set [KC] = BINARY_CHECKSUM(
			   [ID]
			  ,[User]
			  ,[Password]
			  ,[JobTitle]
			  ,[Status]
			  ,[DT_Create]
			) 
			where [ID] = (select [ID] from [inserted]);/**/ 
		END
END
GO