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.
Code:
select id from user where uName='johndoe'
...