sql server - Am looking for SQL conversion using substitution variables of Oracle statement -

am using sql server 2012 , looking conversion of oracle statement having substitution variable:

    update customers     set region = '&region'     state = '&state' 

someone please me on this.

i no means oracle expert think substition variables specific sql*plus , not oracle database.

sql*plus

define region=west define state=california   update customers     set region = '&region'     state = '&state' 

my understanding sql*plus execute following sql:

 update customers     set region = 'west'     state = 'california' 

the equivalent in ms sql server 2012 be:

declare @region varchar(100) declare @state varchar(100)  set @region = 'west' set @state = 'california'  update customers set region = @region state = @state 

or lose variables , use:

update customers set region = 'west' state = 'california' 

edit:

update affect data in table. if add more data table @ later date need run update again.

e.g.

adding more rows state of "california" not automatically set region column "west" inserted rows.

also ensure using same data types (and lengths) variables have declared in table structure.