OSQL TO SQLCMD Conversion

Question

I am trying to convert OSQL comamnd to SQLCMD as below. The OSQL command is working fine,but converted SQLCMD is throwing below error, Please help.

Original OSQL:

osql.exe -S TestDB -E -d TestDB -Q EXIT("Declare @ExecutionResult int  EXEC dbo.p_SP @ExecutionId='test', @ExecutionResult=@ExecutionResult OUTPUT select @ExecutionResult") 2>&1

Converted SQLCMD:

sqlcmd -S tcp:TestDB -E -d TestDB -Q EXIT("Declare @ExecutionResult int  EXEC dbo.p_SP @ExecutionId='test', @ExecutionResult=@ExecutionResult OUTPUT select @ExecutionResult") 2>&1

SQLCMD Error: ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ + CategoryInfo : NotSpecified: (Sqlcmd: 'Declar... '-?' for help.:String) [], RemoteException + FullyQualifiedErrorId : NativeCommandError

Answer 1

Check SQLS**Plus on https://www.sqlsplus.com. It can do much better formatting - loke Oracle' SQL*Plus but for SQL Server.