Dear Sir,

Many thanks for your help, now is done and I add a function for update any table as below:

USE TEMPDB

GO

IF OBJECT_ID('TB') IS NOT NULL DROP TABLE TB

IF OBJECT_ID('FUN_TEST') IS...

Dear Sir/Madam

Is good for me, Many thanks for your help is possible could you give me the function because I have many table need to updated like this so if...

Dear Sir

Many thanks for your help. but field CityName not fixed like:

tblCity { ID CityName}

...