A blog about SQL Server, SSIS, C# and whatever else I happen to be dealing with in my professional life.

Find ramblings

Thursday, August 26, 2010

Unclosed quotation mark after the character string

Just a quick note, I had copied a query out and missed the final bracket in my query and thought it amusing this is the error message the SQL parser kicks back.  Given a query like this

SELECT * FROM dbo.[TABLE1

the parser will kick back the following error message

Msg 105, Level 15, State 1, Line 2
Unclosed quotation mark after the character string 'TABLE1
'.
Msg 102, Level 15, State 1, Line 2
Incorrect syntax near 'TABLE1
'.


No comments: