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

  • forsqlserver

    SSCoach

    Points: 18900

    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

  • Gail Shaw

    SSC Guru

    Points: 1004424

    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

    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: 18900

    I have just one word …Thancs

    Thanks

  • walterbayliss

    SSC Enthusiast

    Points: 140

    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: 5961

    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

    Awesome!

    thanks!

    Cheers.

    Walt

  • farahnasir969

    SSC Enthusiast

    Points: 178

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

  • nazirulfitrifauzi

    SSC Veteran

    Points: 247

    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: 148192

    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: 442077

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

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

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