Posted - 01/12/2013 : 12:53:05
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'
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.