Query table 1 for a value and use that value to delete a row from another table

• rcjay272

  Grasshopper

  Points: 11

  More actions

  January 12, 2013 at 10:59 am

  #268707

  I am new to creating scripts to run on SQL. My goal is to create a script that allows me to query one table for an "id" value and then run a delete statement on another table to delete a row.

  These are the SQL commands I run manually and I would like to automate this so I don't have to get into SQL MGMT Studio each time.

  select id from*user where*uName='johndoe'

  Output

  09123a6b

  Delete from othertable where uid='09123a6b'

  However.....I want to script this so I can run it like a batch file with a variable. Is this possible? Where do I start?

  I would like something like this....this is just an example of how I think it should work.

  c:\deleteuser.bat johndoe

• e4d4

  SSCertifiable

  Points: 5777

  More actions

  January 12, 2013 at 2:35 pm

  #1576634

  Use joins http://msdn.microsoft.com/en-us/library/ms189835.aspx section "C. Using joins and subqueries to data in one table to delete rows in another table"

  delete from othertable

  from othertable o join user u on u.uid=o.uid where u.Name='johndoe';