Hi, I want to call my simple stored procedure in my app's local database. This is my procedure:
ALTER PROCEDURE dbo.booklist AS select * from book RETURN
Actually I should run my query that is simple and return list of books (SELECT * FROM book). I should do this job via stored procedure(school stuff).
How can I have booklist in a data-table. Should I have Parameter for execute this procedure?