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
懒得写,复制别人的