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