If we can execute multiple sql statements inside a stored procedure. What will be the result of this stored procedure ?
create procedure usp_test
select * from order_table
select * from product_table
Interview question and answer by: Akiii
| Posted on: 5/30/2012 | Category: SQL Server Interview questions
| Views: 1018 | | Points: 40
When the stored procedure is executed, it will fetch all the rows of the order_table and product_table collectively !
Thanks and Regards
Found interesting? Add this to: