How to Delete Multiple ID

• jaquino012

  SSC-Addicted

  Points: 431

  More actions

  September 2, 2015 at 1:03 am

  #150921

  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.

• Phil Parkin

  SSC Guru

  Points: 246957

  More actions

  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'

  The absence of evidence is not evidence of absence
  - Martin Rees
  The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
  - Phil Parkin

• jaquino012

  SSC-Addicted

  Points: 431

  More actions

  September 2, 2015 at 5:08 am

  #1823915

  Hi,

  Thank you for you reply..

  Vb.net and datagridview control.

  The user will select a row by check box

  Interger

  Thanks

  Thanks