存储过程是在SQL server服务器上创建、运行的过程,用来完成特定的任务。由于存储过程只在第一次执行时编译,以后执行时无需编译,因此语句的执行速度较快。
eg.
表名:bookInfo
列名 数据类型
bookID int
bookName nvarchar(50)
bookPrice smallmoney
创建一个存储过程,插入一行数据到该表中,插入成功输入0,插入失败输入1
create
PROCEDURE
[
dbo
]
.
[
bookInsert_Procedure
]
@bookid int ,
@bookname nvarchar ( 50 ),
@bookprice smallmoney
AS
BEGIN
insert into bookInfo(bookID,bookName,bookPrice) values ( @bookid , @bookname , @bookprice )
if @@error = 0 print 0
else print 1
END
@bookid int ,
@bookname nvarchar ( 50 ),
@bookprice smallmoney
AS
BEGIN
insert into bookInfo(bookID,bookName,bookPrice) values ( @bookid , @bookname , @bookprice )
if @@error = 0 print 0
else print 1
END