What is MARS

• vsamantha35

  SSChampion

  Points: 11551

  More actions

  December 7, 2019 at 10:13 am

  #3705643

  Hi Experts,

  What is actually meant by Multiple Active Result Sets (MARS) in SQL Server? Can anyone give an example. I always get confused with this term.

  Is below tsql block can be considered as MARS ?

  select * from T1; --result set 1

  select * from T2; --result set 2

  select * from T3; --result set 3

  Thanks,

  Sam

• Site Owners

  SSC Guru

  Points: 80356

  More actions

  December 8, 2019 at 11:10 am

  #3705733

  Thanks for posting your issue and hopefully someone will answer soon.

  This is an automated bump to increase visibility of your question.