简单存储过程语句

来源:互联网 发布:linux运行nodejs 编辑:程序博客网 时间:2024/06/01 07:58

IF EXISTS(SELECT  *

            FROM    dbo.sysobjects

            WHERE   id = OBJECT_ID(N'[dbo].[pro_RelateProSelect]')

                    ANDOBJECTPROPERTY(id,N'IsProcedure') = 1 )

    DROP PROCEDURE [dbo].[pro_RelateProSelect]

GO

CREATE PROCEDUREpro_RelateProSelect

    @ProTypeId AS NVARCHAR(50),

    @ProId AS INT

AS

SELECT TOP 4* FROM dbo.TbProductWHERE ProTypeId=@ProTypeIdAND ProId != @ProId

go


==============================

注册存储过程

CREATE PROCEDUREpro_RegisterInsertData

    @UserName AS NVARCHAR(50),

    @UserPwd AS NVARCHAR(50),

    @UserSex AS NVARCHAR(50),

    @UserEmail AS NVARCHAR(50),

    @UserAddressASNVARCHAR(50),

    @RegisterTimeASDATETIME

AS

  INSERT INTO dbo.TbUser

          (userName ,

            userPwd,

            userEmail,

            userAddress,

            userSex,

            registerTime

          )

  VALUES  (@UserName, -- userName - nvarchar(50)

            @UserPwd,-- userPwd -nvarchar(50)

            @UserEmail,-- userEmail -nvarchar(50)

            @UserAddress,-- userAddress -nvarchar(50)

            @UserSex,-- userSex -nvarchar(50)

            @RegisterTime

          )

go



原创粉丝点击