rianto isaac's Weblog

rianto utomo isaac sahala utomo

sql, server cross database multi database

leave a comment »

-- Create View
CREATE VIEW CrossDBView
WITH SCHEMABINDING
AS
SELECT t1.ID AS t1id, t2.ID AS t2id
FROM Test1.dbo.Table1 t1
INNER JOIN Test2.dbo.Table2 t2 ON t1.ID = t2.ID

rianto utomo bole nyontek dari http://blog.sqlauthority.com/2010/09/23/sql-server-cross-database-queries-not-allowed-in-indexed-view-limitation-of-the-view-7/

Written by isaaconi

April 7, 2011 pada 2:01 pm

Tinggalkan Balasan

Isikan data di bawah atau klik salah satu ikon untuk log in:

Logo WordPress.com

You are commenting using your WordPress.com account. Logout / Ubah )

Gambar Twitter

You are commenting using your Twitter account. Logout / Ubah )

Foto Facebook

You are commenting using your Facebook account. Logout / Ubah )

Foto Google+

You are commenting using your Google+ account. Logout / Ubah )

Connecting to %s

%d blogger menyukai ini: