Is it possible to write more than 2 sql statements in a stored procedure like

select * from tablename
select * from tablename
select * from Tablename

 Posted by Kk86kiran on 4/16/2012 | Category: Sql Server Interview questions | Views: 5938 | Points: 40
Select from following answers:
  1. Yes
  2. No
  3. No idea
  4. All Above

Show Correct Answer

Asked In: Many Interviews | Alert Moderator 

Comments or Responses

Posted by: Pgbhadane on: 4/17/2012 | Points: 10
Posted by: Pykhairnar4u on: 4/18/2012 | Points: 10
Yes its possible to declare more than two sql statement into store procedure. After execution of SP you will get two data table as output.

Login to post response

More Interview Questions by Kk86kiran