select name FROM MASTER.DBO.SYSDATABASES where left(name,3)='UFT' ORDER BY NAME
OPEN My_Cursor
FETCH NEXT FROM My_Cursor INTO @Name
WHILE @@FETCH_STATUS = 0
BEGIN
IF @Name=@UFTSystem
BEGIN
EXEC('UPDATE ' + @Name + '..EAP_User SET Name='''+@NewMobileID+''',mobile= '''+@NewMobileID+''' WHERE mobile='''+@OldMobileID+'''')
END
ELSE
BEGIN
EXEC('UPDATE ' + @Name + '..EAP_User SET Name ='''+@NewMobileID+''', mobile = '''+@NewMobileID+''',DuduPhone = '''+@NewMobileID+''' WHERE mobile = '''+@OldMobileID+'''')
