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