最简单的插入的存储过程

最新推荐文章于 2022-08-24 18:09:12 发布

zgh2002007

最新推荐文章于 2022-08-24 18:09:12 发布

阅读量545

点赞数

文章标签：存储 null email output insert

本文链接：https://blog.csdn.net/zgh2002007/article/details/1386400

版权

CREATE PROCEDURE InsertUser
    @ID        INT = NULL OUTPUT,
    @Name      NVARCHAR(50) = NULL,
    @Password NVARCHAR(50) = NULL,
    @ShortName NVARCHAR(50) = NULL,
    @Sex       NVARCHAR(50) = NULL,
    @BirthDate NVARCHAR(50) = NULL,
    @OffcialPhone NVARCHAR(50) = NULL,
    @Fax       NVARCHAR(50) = NULL,
    @MobilePhone NVARCHAR(50) = NULL,
    @Email     NVARCHAR(50) = NULL,
    @Sequence NVARCHAR(50) = NULL,
    @Remark    NVARCHAR(50) = NULL,
    @Flag      INT = NULL,
    @DepartmentCode INT = NULL

/*
(
@parameter1 int = 5,
@parameter2 datatype OUTPUT
)
*/
AS
SET NOCOUNT ON
set xact_abort on
begin transaction
     insert UserInfo (Name,
                       Password,
                       ShortName,
                       Sex,
                       BirthDate,
                       OfficalPhone,
                       Fax,
                       MobilePhone,
                       Email,
                       Sequence,
                       Remark,
                       Flag,
                       DepartmentCode)

    select @Name,
           @Password,
           @ShortName,
           @Sex,
           @BirthDate,
           @OfficalPhone,
           @Fax,
           @MobilePhone,
           @Email,
           @Sequence,
           @Remark,
           @Flag,
           @DepartmentCode

    select @ID = @@identity
    commit transaction
RETURN 0