from: http://www.cnblogs.com/jackyrong/archive/2006/11/15/561287.html
In SQL SERVER 2005, a synonym has finally appeared, which makes it much easier to use. Here's a small example to illustrate
Synonyms are database objects that are used to achieve the following purposes:
Provides alternate names for another database object (called a "base Object") on a local or remote server.
Provides an extract layer that prevents the name or location of the base object of the client application from being changed.
For example, the employee table for Adventure Works is on a server named Server1. To refer to this table from another server Server2, the client application must use a four-part name Server1.AdventureWorks.Person.Employee. Also, if you change the location of the table (for example, to another server), you need to modify the client application to reflect the changes. Some features have been summed up in http://www.cnblogs.com/jackyrong/archive/2006/06/15/426304.html, and examples are given here, examples from foreigners.
Set up two databases first
Create Database Riverresearch
Go
Use Riverresearch
Go
Then set up the schema and table for two databases, and the stored procedures are as follows
Use rainbowresearchgocreate schema raingocreate schema snowgocreate table Rainbowresearch.Rain.Cities (ID int., City varch AR (+)) Goinsert into Rainbowresearch.Rain.Cities Select 1, ' Hongkong ' inserts into Rainbowresearch.Rain.Cities select 2, ' Tokyo ' INSERT into Rainbowresearch.Rain.Cities select 3, ' Beijing ' insert into Rainbowresearch.Rain.Cities Select 4, ' Ta Ipei ' INSERT into Rainbowresearch.Rain.Cities Select 5, ' Seoul ' insert into Rainbowresearch.Rain.Cities Select 6, ' Mumbai ' Gocreate procedure rain.displaycities @id intasselect city from Rainbowresearch.Rain.Cities where [email protected ]gocreate table Rainbowresearch.Snow.Cities (id int, city varchar) Goinsert to Rainbowresearch.Snow.Cities Select 1, ' Tokyo ' insert into Rainbowresearch.Snow.Cities select 2, ' Seoul ' insert into Rainbowresearch.Snow.Cities select 3, ' Mo Scow ' INSERT into Rainbowresearch.Snow.Cities Select 4, ' NewYork ' gocreate procedure snow.displaycities @id intasselect Ci Ty from Rainbowresearch.Snow.CiTies where [email protected]gouse riverresearchgocreate Schema rivergogocreate table RiverResearch.River.Cities ( ID int, city varchar (goinsert) to RiverResearch.River.Cities Select 1, ' Hongkong ' insert into RIVERRESEARCH.RIVER.C Ities Select 2, ' Tokyo ' insert into RiverResearch.River.Cities select 3, ' Beijing ' insert into RiverResearch.River.Cities Select 4, ' Taipei ' insert into RiverResearch.River.Cities Select 5, ' Seoul ' gocreate procedure river.displaycities @id int Asselect City from RiverResearch.River.Cities where[email protected]Go
Here, in the Rainbowresearch database set up two patterns, Rain,snow, and then set up in these two modes of the city table, and in
Riversearch database also established a model river, also set up a table cities, so simple, not detailed description.
After that, we query the content that was just built.
SELECT * FROM RiverResearch.River.Citiesgoselect * from Rainbowresearch.Rain.Citiesgoselect * FROM Rainbowresearch.Snow.Citiesgo
Finally, we create synonyms
Use rainbowresearchgocreate synonym rivercities for RiverResearch.River.Citiesgocreate synonym raincities For Rainbowresearch.Rain.Citiesgocreate synonym snowcities for Rainbowresearch.Snow.Citiesgouse Riverresearchgocreate synonym rivercities for RiverResearch.River.Citiesgocreate synonym raincities for Rainbowresearch.Rain.Citiesgocreate synonym snowcities for Rainbowresearch.Snow.Citiesgo
You see, it's a lot easier.
Check again, it's a lot easier this time.
Use Riverresearchgoselect * from Rivercitiesselect * from Raincitiesselect * from Snowcitiesgouse rainbowresearchgoselect * FROM Rivercitiesgoselect * from Raincitiesgoselect * from Snowcitiesgo
---------------------->>>