page 267 to page 290.txt

Sql statement it is very cute

SELECT * FROM FS1.Sample_Snapshot.dbo.NW_Customers


EXEC sp_addlinkedserver 'FS1', 'SQL Server'


EXEC sp_serveroption 'FS1', 'data access', true


SELECT * FROM FS1.Sample_Snapshot.dbo.NW_Customers


SELECT * FROM FS1.Sample_Snapshot.dbo.NW_Customers


EXEC sp_addlinkedsrvlogin 'FS1', false, 'SYSTEMATIC\Vincent', 'sa', NULL


SELECT * FROM FS1.Sample_Snapshot.dbo.NW_Customers


PRINT DB_ID('Northwind')


USE Northwind
SELECT * FROM Customers
SELECT * FROM Suppliers