今天使用sQL2005中Try_catch,以及分布式使用远程服务的函数

declare @mobileNum varchar(20)
declare @Prov  varchar(10)

declare mo_cursor cursor for select MobileNo from SrcMobile

truncate table DesMobile
open mo_cursor

fetch next from mo_cursor into @mobileNum

WHILE @@FETCH_STATUS = 0
BEGIN
begin try

PRINT '---------------------------------'

 Select top 1 @Prov=Mprov  from Openquery([192.168.1.5],'select ImpsOlap.dbo.GetProvince(13480525865) Mprov')

 begin

 insert into DesMobile(MobileNo,Province) values(@mobileNum,@Prov)

 end

fetch next from mo_cursor into @mobileNum

end try

begin Catch
PRINT @mobileNum
fetch next from mo_cursor into @mobileNum
 --continue
end Catch

END

close mo_cursor
DEALLOCATE mo_cursor