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

 Posted by Akiii on 5/30/2012 | Category: Sql Server Interview questions | Views: 2107 | 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


| Alert Moderator 

Comments or Responses

Login to post response