创建新的存储过程

select  存储过程

CREATE PROCEDURE   Sp_dream_Select   (@ID  Bigint )  AS

   SELECT  name,password 
  FROM  dream  WHERE  ID  =  @ID
GO

insert存储过程

CREATE PROCEDURE  Sp_dream_Edit   
(
   @ID     bigint      output ,      --成功后返回单据ID
 @name   varchar (14),
 @password      varchar(60),
      )
    AS
     BEGIN
         INSERT INTO  dream(id,name,password )
          VALUES (@id,@name,@password );
    END
RETURN
GO

update存储过程

CREATE PROCEDURE  Sp_dream_Edit   
(
  @ID     bigint      output ,      --成功后返回单据ID
  @name    varchar(14), 
  @password varbinary(256)
)
     AS

     BEGIN 
          UPDATE   dream
                  SET 
  name  = @name,
  password   = @password ,
  
          WHERE   id = @id;

     END
 

RETURN
GO

转载于:https://www.cnblogs.com/jobs2/archive/2012/10/07/2714153.html