stored procedure

 avatar
unknown
c9search
4 years ago
809 B
6
Indexable
USE [scoot]
GO
/****** Object:  StoredProcedure [dbo].[insert_works]    Script Date: 08/12/2021 21:20:23 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO

ALTER PROCEDURE [dbo].[insert_works]

		    @name nvarchar(50) NULL 
           ,@date_work date NULL
           ,@place nvarchar(50) NULL
		   ,@responsable nvarchar(50) NULL
		   ,@section nvarchar(50) NULL
           ,@remarque nvarchar(50) NULL
           ,@mois nvarchar(50) NULL
AS
BEGIN
	INSERT INTO [dbo].[works]
           ([name]
           ,[date_work]
           ,[placee]
           ,[responsable]
           ,[section]
           ,[remarque]
           ,[mois])
     VALUES(
            @name
           ,@date_work
           ,@place
           ,@responsable
           ,@section
           ,@remarque
           ,@mois)
		   
END
Editor is loading...