简单存储过程语句

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 PROCEDURE pro_RelateProSelect

    @ProTypeId AS NVARCHAR(50) ,

    @ProId AS INT

AS

SELECT TOP 4 * FROM dbo.TbProduct WHERE ProTypeId=@ProTypeId AND ProId != @ProId

go

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

注册存储过程

CREATE PROCEDURE pro_RegisterInsertData

    @UserName AS NVARCHAR(50) ,

    @UserPwd AS NVARCHAR(50) ,

    @UserSex AS NVARCHAR(50) ,

    @UserEmail AS NVARCHAR(50) ,

    @UserAddressAS NVARCHAR(50),

    @RegisterTimeAS DATETIME

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