Parsing in SQL Server 2005

• karthik -450760

  Ten Centuries

  Points: 1362

  More actions

  November 5, 2009 at 2:10 pm

  #211932

  Hi,

  Can any let me know what exactly happens @ background when a query is parsed in sql server?

  I know that sql server check for syntax of the statement.. does it also check if the particular objects referenced in the statement exists in the database or not?

  Please let me know if there are any links that explains parsing in detail..

  thanks

• GSquared

  SSC Guru

  Points: 260824

  More actions

  November 5, 2009 at 2:12 pm

  #1075611

  Parsing just checks syntax. Compiling checks for objects.

  - Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
  Property of The Thread

  "Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon