Home Forums SQL Server 2005 T-SQL (SS2K5) How to Delete Multiple ID RE: How to Delete Multiple ID

  • September 2, 2015 at 1:23 am

    #1823883

    jaquino012 (9/2/2015)

    Hi Experts,

    How can i accomplish to delete a selected ID's using T-SQL.

    I have use this query DELETE FROM `table` WHERE id IN (264, 265).

    But if my parameters are selected, means it can be two or three based on the selected number rows by a user.

    How can u implement above query.

    Thanks.

    How is the user performing the selection? Which client software are they using? What does the Id recordset look like? Comma-delimited string? For example '264,265'

    If you haven't even tried to resolve your issue, please don't expect the hard-working volunteers here to waste their time providing links to answers which you could easily have found yourself.