CODEWITHSUNDEEP
sql-servert-sqlsyntax-error
Hakan Kiyar
Hakan Kiyar

Reputation: 1209

MS-SQL 2008 Server : Wrong Syntax?

I having a problem with this command line:

IF  EXISTS (SELECT * FROM sys.objects
            WHERE object_id = OBJECT_ID(N'dbo.njams_test_sql_2.[PROC_DELETE_DATA]')
             AND type in (N'P', N'PC'))
DROP PROCEDURE [PROC_DELETE_DATA]
GO

Following SubSelect-Command:

SELECT * FROM sys.objects
WHERE object_id = OBJECT_ID ( N'dbo.njams_test_sql_2.[PROC_DELETE_DATA]'

Gives the error that there is an syntax error in the near of

'dbo.njams_test_sql_2.[PROC_DELETE_DATA]'

What am I doing wrong?

Upvotes: 0

Views: 68

Answers (2)

Fabian Bigler
Fabian Bigler

Reputation: 10895

a bracket is missing at the end

SELECT * FROM sys.objects
WHERE object_id = OBJECT_ID ( N'dbo.njams_test_sql_2.[PROC_DELETE_DATA]' )

Upvotes: 2

Rahul Bhati
Rahul Bhati

Reputation: 296

Your first query runs perfectly.. but you are missing ')' in your second query.

Use following query

SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'dbo.njams_test_sql_2.[PROC_DELETE_DATA]')

Upvotes: 0

Related Questions