Difference between SQL queries and batches?

• Shadab Shah

  SSCarpal Tunnel

  Points: 4759

  More actions

  October 3, 2012 at 3:41 am

  #268740

  Hi ,

  I am newbie. I would like to what is the difference between SQL queries and Batches. According to MSDN Batches means "A batch is a group of one or more Transact-SQL statements" and to me the same means SQL Queries. In SQL queries we can have more then one T-SQL statement. So what is the difference between the two?

• Gail Shaw

  SSC Guru

  Points: 1004504

  More actions

  October 3, 2012 at 3:52 am

  #1544765

  A query is a single select, insert, update or delete (or related) statements. A batch is a set of one or more statements that are submitted to the server as a single unit.

  Gail Shaw
  Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
  SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

  We walk in the dark places no others will enter
  We stand on the bridge and no one may pass

• laurie-789651

  SSCertifiable

  Points: 7680

  More actions

  October 3, 2012 at 4:06 am

  #1544779

  Batches are terminated by the GO command.

  See: http://msdn.microsoft.com/en-us/library/ms188037.aspx

• Jeff Moden

  SSC Guru

  Points: 1004595

  More actions

  Follow

  October 3, 2012 at 6:13 am

  #1544845

  laurie-789651 (10/3/2012)

  ---

  Batches are terminated by the GO command.

  See: http://msdn.microsoft.com/en-us/library/ms188037.aspx

  Only in a script. The execution of a stored procedure (for example) can be considered to be a "batch" depending on how it's called.

  --Jeff Moden

  ---

  RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
  First step towards the paradigm shift of writing Set Based code:
  ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

  Change is inevitable... Change for the better is not.
  

  ---

  Helpful Links:
  How to post code problems
  How to Post Performance Problems
  Create a Tally Function (fnTally)
  

• Gail Shaw

  SSC Guru

  Points: 1004504

  More actions

  October 3, 2012 at 6:33 am

  #1544863

  And a script without any GO is a single batch, no matter how long it is.

  Gail Shaw
  Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
  SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

  We walk in the dark places no others will enter
  We stand on the bridge and no one may pass