USE [Mt222bm_project]
GO
/****** Object:  StoredProcedure [UserSchema].[uspInsertMatchs]    Script Date: 05/25/2011 12:40:26 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER PROCEDURE [UserSchema].[uspInsertMatchs]
@MatchID INT OUTPUT,
@TypID INT,
@Hemmalag VARCHAR (25),
@Bortalag VARCHAR (25),
@Resultat VARCHAR(25),
@datum datetime2 (4)
AS
    BEGIN
        SET NOCOUNT ON;

        INSERT INTO DBO.MATCH
            (Hemmalag,Bortalag,Resultat,Datum,TypID)
            VALUES
            (@Hemmalag,@Bortalag,@Resultat,@datum,@TypID )
        SET @Matchid = SCOPE_IDENTITY()

    END