链接数据失败时候的连接方法

create trigger tri_update_pwd

on admin

for update

as

declare @password varchar(50)

declare @user varchar(50)

if update([password])

  begin

    select @user=inserted.admin,@password=inserted.[password]

    from inserted,admin

    where inserted.admin=admin.admin

   

    update openrowset('sqloledb','10.91.*。*';'sa';'pwd',barcodep.dbo.admin)  set [password]=@password

      where admin=@user        --openrowset打开远程数据库的某一个表

    

 

  end