USE OPENSOURCE U CAN INSERT OR UPDATE TABLE ONE DATABSE TO ANOHTERONE.
FOR EXAMPLE
USE PUBS
INSERT INTO Categories
SELECT *
FROM OPENDATASOURCE(
'SQLOLEDB',
'Data Source=ServerNa me;User ID=MyUID;Passwo rd=MyPass'
).Northwind.dbo .Categories
WHERE CategoryID NOT IN (SELECT CategoryID FROM Categories)
raveengo
Last Activity: Mar 11 '10, 11:41 AM
Joined: Mar 11 '10
Location:
-
--try this which are the customers are not billed between to days
select custid,custname from customer where custid not in(
select custid from bill where billdate between @fromdate and @todate)Leave a comment:
-
Update a set a.regdate=b.reg date from xyz a,abc b
where a.code=b.code and a.name=b.name and a.regdate<>b.re gdateLeave a comment:
-
The SQL Server 2000 Developer Edition supports all of the SQL Server 2000
features, other than graphical utilities support for language settings. This
edition is for programmers developing applications that use SQL Server 2000
as their data store. This edition is licensed for use only as a development
and test system, not a production server.
In addition, the Enterprise version can only be installed on Server...Leave a comment:
No activity results to display
Leave a comment: