实例解析：将count(*)值写入另一个表中

use db1gocreate table t1(Item   varchar(100),Prov   varchar(100),Qty    int);insert into t1(item,prov,qty)   select '原名','xx省',(select count(*) from updata where id='A0101');

use db2gocreate table t2(Item   varchar(100),Prov   varchar(100),Qty    int);INSERT   INTO  t2(item,prov,qty) select '原名','xx省',(select count(*)FROM OPENDATASOURCE('SQLOLEDB', 'Data Source=YY/IIDC;User ID=sa;Password=password').db1.dbo.updata whereculindexid='A0101')