Home Forums SQL Server 2008 T-SQL (SS2K8) delete top 100 RE: delete top 100

  • July 17, 2013 at 3:38 pm

    #1633466

    Voide (7/17/2013)

    riya_dave (7/17/2013)

    hi

    my query is giving me erro

    delete top(1000) from table a

    join table b

    on a.id = b.id

    and b.date < getdate()

    error: incorrect syntax near a.

    i want to delete top 1000 from table a

    :blink:

    What surprises you? It's totally valid and equal to a where in this case.

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2