CODEWITHSUNDEEP
sql-servert-sqlsql-server-2008r2-express
SkeetJon
SkeetJon

Reputation: 1491

What SQL syntax is this?

Can anyone tell me what SQL syntax this is please where 123 is the argument passed to the SP?

EXECUTE sp_MyStoredProcedure = '123'

When executing this command the error message from MSSMS is

102, Level 15, State 1, Line 6
syntax near '='.

We need to configure the DB (SQL Server 2008 Express) to accept SQL of this syntax as it is generated by a windows service that we can't change. Trying to set the DB compatibility doesn't work...

ALTER DATABASE ABC SET Compatibility_Level = 80 / 90 / 100
EXECUTE sp_dbcmptlevel 'ABC', 80   --80,90, 100

Thanks in advance

Upvotes: 0

Views: 103

Answers (3)

SkeetJon
SkeetJon

Reputation: 1491

The syntax was invalid. The SQL in the windows service was obsolete.

Upvotes: 0

Asif
Asif

Reputation: 2677

EXECUTE sp_MyStoredProcedure '123'

Upvotes: 1

usr
usr

Reputation: 171246

According to the help topic, this syntax is just invalid and apparently never was valid for SQL Server. It looks nonsensical, too. Does it work for some other DBMS?

Upvotes: 2

Related Questions