SELECT * FROM OPENROWSET(
'Microsoft.ACE.OLEDB.12.0',
'Excel 12.0;Extended Properties=Excel 12.0;Database=D:\mssql\book1.xls;HDR=NO;IMEX=1',
'SELECT * FROM [Sheet1$]')
Wednesday, March 7, 2012
Tuesday, March 6, 2012
UPDATE Column(s) one table from a table in another database
Select Database Where update needs
Or Write USE Database
If Database selected then no need to write USE DB1
USE DB1 --(optional)
UPDATE DB1.dbo.MyTable
SET
Field1 = d2.Field1,
Field2 = d2.Field2,
Field3 = d2.Field3
FROM DB2.dbo.MyTable d2
WHERE d2.MyKey = MyTable.MyKey
Or Write USE Database
If Database selected then no need to write USE DB1
USE DB1 --(optional)
UPDATE DB1.dbo.MyTable
SET
Field1 = d2.Field1,
Field2 = d2.Field2,
Field3 = d2.Field3
FROM DB2.dbo.MyTable d2
WHERE d2.MyKey = MyTable.MyKey
Subscribe to:
Posts (Atom)
