Got script with such an expression (sorry, but Code applet eats carriage returns)
print ('Some text
!! Some more text')
SQLCMD version 1.6.0 gives error
"Some" is not recognized as an internal or external command, operable program or batch file. Msg 105, Level 15, State 1, Server SRV, Line 1 Unclosed quotation mark after the character string "Some text". Msg 102, Level 15, State 1, Server SRV, Line 1 Incorrect syntax near "Some text".
I found it in
raiserror ('Some text
!! Some more text', 10, 0)
Nevertheless
print 'Some text
!! Some more text'
works fine.
So the problem not just in two exclamations in new line, but using parenthesis as well.
Previous versions works fine (I mean old SDK versions installed with SQL server or other way in C:\Program Files\Microsoft SQL Server\Client SDK\ODBC\170\Tools\Binn).
Got script with such an expression (sorry, but Code applet eats carriage returns)
print ('Some text !! Some more text')
SQLCMD version 1.6.0 gives error
"Some" is not recognized as an internal or external command, operable program or batch file. Msg 105, Level 15, State 1, Server SRV, Line 1 Unclosed quotation mark after the character string "Some text". Msg 102, Level 15, State 1, Server SRV, Line 1 Incorrect syntax near "Some text".
I found it in
raiserror ('Some text !! Some more text', 10, 0)
Nevertheless
print 'Some text !! Some more text'
works fine.
So the problem not just in two exclamations in new line, but using parenthesis as well.
Previous versions works fine (I mean old SDK versions installed with SQL server or other way in C:\Program Files\Microsoft SQL Server\Client SDK\ODBC\170\Tools\Binn).