Proc_GetBorrowHistory.txt
上传用户:gooyliu
上传日期:2018-09-29
资源大小:5816k
文件大小:0k
- CREATE PROC Proc_GetBorrowHistory
- @userID NVARCHAR(50)
- AS
- SELECT * FROM Book WHERE bookID IN(
- SELECT bookID FROM BorrowRec WHERE readerID=@userID AND borrowStatus='False')
- EXEC Proc_GetBorrowHistory '002'