>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!
That will work fine.
Brad