Write the count (*) value to another table.

1. Write Data to another table in the same database:
Copy codeThe Code is as follows:
Use db1
Go
Create table t1 (
Item varchar (100 ),
Prov varchar (100 ),
Qty int );
Insert into t1 (item, prov, qty)
Select 'original name', 'xx province ',
(Select count (*)
From updata where id = 'a0101 ');


2. Write the table to another database:
Copy codeThe Code is as follows:
Use db2
Go
Create table t2 (
Item varchar (100 ),
Prov varchar (100 ),
Qty int );
Insert into t2 (item, prov, qty)
Select 'original name ',
'Xx province ',
(Select count (*)
From opendatasource ('sqloledb ',
'Data Source = YY \ IIDC;
User ID = sa;
Password = password ').
Db1.dbo. updata where
Culindexid = 'a0101 ')