insert_book.sql

图书馆系统建立

CREATE PROCEDURE [insert_book]
	(@book_id_1 	[int],
	 @book_name_2 	[char](50),
	 @book_pub_3 	[char](80),
	 @book_price_4 	[smallmoney],
	 @book_author_5 	[char](50),
	 @book_intr_6 	[varchar](500),
	 @book_address_7 	[char](50),
	 @book_state_id_8 	[int],
	 @type_id_9 	[int])

AS INSERT INTO [LibraryManageSystemDatebase].[dbo].[book_info] 
	 ( [book_id],
	 [book_name],
	 [book_pub],
	 [book_price],
	 [book_author],
	 [book_intr],
	 [book_address],
	 [book_state_id],
	 [type_id]) 
 
VALUES 
	( @book_id_1,
	 @book_name_2,
	 @book_pub_3,
	 @book_price_4,
	 @book_author_5,
	 @book_intr_6,
	 @book_address_7,
	 @book_state_id_8,
	 @type_id_9)
GO