In SQL, I am trying to write a procedure to retrieve and output the book_code, title, type, price for every book whose publisher code is stored in I_AUTHOR_NUM.
This is what I have so far:
create procedure usp_disp_author_code
(select publisher_code from inserted)
set book_code = @bookcde
where publisher_code = @publishercde
OK! Not sure on this but I was looking for some one to give me feedback good or bad. Or point me in the right direction.
Thank you, Diana M
View Complete Post