Msg 102, Level 15, State 1, Line 1 Incorrect syntax near '-'.

Question

Msg 102, Level 15, State 1, Line 1 Incorrect syntax near '-'.

forsqlserver

SSCoach

Points: 18902
More actions
June 2, 2009 at 5:27 am

#134486

If I have connected a linked server whose name is: cic-nic-2
When I running query : select * from cic-nic-2.Arrow.dbo.circle
it is giving error :
Msg 102, Level 15, State 1, Line 1
Incorrect syntax near '-'.
One thing more if I want to run this query using server IP address not with name could it be possible.
Thanks

Viewing 11 posts - 1 through 10 (of 10 total)

You must be logged in to reply to this topic. Login to reply

Gail Shaw SSC Guru Points: 1004504 More actions · Answer 1

Put square brackets around the linked server name.

Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

Ramesh Saive SSC-Insane Points: 24275 More actions · Answer 2

You have to enclose the object names in [] when the object name contains special characters, keywords etc.

select * from [cic-nic-2].Arrow.dbo.circle

--Ramesh

forsqlserver SSCoach Points: 18902 More actions · Answer 3

forsqlserver

SSCoach

Points: 18902

June 2, 2009 at 5:58 am

#1003341

I have just one word ...Thancs

Thanks

walterbayliss SSC Enthusiast Points: 140 More actions · Answer 4

Thanks Guys.

What about this one.

SELECT _BODY from aaa.dbo.aaa2 REPLACE('from a blogis easy', 'blogis', 'blog is')

I am getting the same error - Have tried Square brackets every where. to no avail.

Any clues?

david.alcock SSCertifiable Points: 6021 More actions · Answer 5

Try:

SELECT _BODY, REPLACE('from a blogis easy', 'blogis', 'blog is') from aaa.dbo.aaa2

The replace needs to be in the SELECT before the FROM clause.

'Only he who wanders finds new paths'

walterbayliss SSC Enthusiast Points: 140 More actions · Answer 6

walterbayliss

SSC Enthusiast

Points: 140

February 3, 2011 at 2:12 pm

#1282152

Awesome!

thanks!

Cheers.

Walt

farahnasir969 SSC Enthusiast Points: 178 More actions · Answer 7

I apply foreign key on my table but when i am add value its generate error of primary key

nazirulfitrifauzi SSC Veteran Points: 277 More actions · Answer 8

SELECT 'KESELURUHAN' AS STATE,
'KESELURUHAN' AS BRANCH,
dbo.uf_get_koddana(h.funding_scheme) AS Dana,
Count(*) AS cnt_all,
Sum(h.approved_limit) AS sum_all,
Sum(isnull(w.wo_amt,0)) AS sum_wo,
Sum(isnull(RECOVERED_AMOUNT,0)) AS sum_wb,
Sum(case when bulantgkbil >= 7 and h.account_status not in (1,9,15) then 1 else 0 END) AS cnt_npl,
Sum(case when bulantgkbil >= 7 and h.account_status not in (1,9,15) then isnull(instal_arrears,0) - isnull(income_arrears,0)
Else 0 END) AS npl_costarr,
Sum(case when bulantgkbil >= 7 and h.account_status not in (1,9,15) then isnull(income_arrears,0) else 0 END) AS npl_prftarr,
Sum(case when account_status = 9 then 1 else 0 END )as bil_wo
FROM dbo.account_history h,
dbo.Write_off_report w
WHERE ssma_oracle.trunc(h.report_date) = convert(DATETIME, '2016-06-30')
AND h.account_no = w.new_account (+)
AND h.account_status not in (2,16)
GROUP by dbo.uf_get_koddana(h.funding_scheme)

what im missing?? im getting this error : Msg 102, Level 15, State 1, Line 16

Incorrect syntax near ')'.

John Mitchell-245523 SSC Guru Points: 148809 More actions · Answer 9

Assuming you're running this in SSMS, you can double-click on the error and it'll take you to the line in the code. In this instance, I think it's the "(+)". What is that supposed to do?

John

Lynn Pettis SSC Guru Points: 442467 More actions · Answer 10

Oracle outer join?? No join criteria in the from clause, looks like ANSI-89 style joins in use.