Create a Stored Procedure

 

		USE x3u8
		GO
		SET ANSI_NULLS ON
		GO
		SET QUOTED_IDENTIFIER ON
		GO
		CREATE PROCEDURE [dbo].[StoredProcExample]
			@DATE datetime2(7),
			@USER nvarchar(50) 
		AS 
		BEGIN 
			SET NOCOUNT ON; 
			BEGIN 
				INSERT INTO dbo._EXAMPLE (DATE,[USER])
				VALUES(@DATE, @USER)
			END 
		END
		GO