sql - Missing Bracket Frustration -

sql - Missing Bracket Frustration -

i have sql where clause 2 pages long. appear missing bracket. there way in sql count right brackets , left brackets , determine problem is. reply may no interested know if is, meaning not have go through hundreds of lines of code 1 line @ time.

you can utilize sql pretty printer automatically format sql statement. should help find unbalanced parenthesis.

there many tools available purpose, here's online service use:

http://www.dpriver.com/pp/sqlformat.htm

various other tools sql server management studio integration can found in question:

pretty printer t-sql?

sql sql-server