I need to update a database running on a SQL Server engine. I've never used SQL Server, but I've been told to prepare the scripts to make the change.
My records have a compound primary key.
I need to do a bunch of SQL scripts (or one script) that replaces part of the key (lookup_key) with a different value for ONE practitioner.
Is this ok for SQL Server SQL scripts?
* fix_lookup.sql
update master_cred set lookup_key = '2974' where lookup_key = '[974'
update group_detail set lookup_key = '2974' where lookup_key = '[974'
* etc
Will that work? Is all the puncuation correct for multiple update commands in a single file?
Thanks!
--Todd Sherman
-Wake Up! Smell the Coffee!