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!