sqlserver同义词:SQL SERVER 2005中同义词例子来源: 发布时间:星期六, 2009年1月10日 浏览:42次 评论:0
="t18">在SQL SERVER 2005中
 终于出现了同义词了大大方便了使用 下面举个小例子介绍说明同义词是用来实现下列用途  数据库对象: 为本地或远程服务器上 另 个数据库对象(称为“基对象”)提供备选名称提供 个提取层该层防止客户端应用 基对象名称或位置被更改 例如 名为 Server1 服务器上有 Adventure Works Employee 表若要从另台服务器 Server2 引用此表客户端应用必须使用由 4个部分构成名称 Server1.AdventureWorks.Person.Employee另外如果更改了表位置(例如更改到另台服务器上)那么需要修改客户端应用以反映所做更改 的前在http://www.cnblogs.com/jackyrong/archive/2006/06/15/426304.html中已经归纳了些特性现在在举出例子例子来自老外首先建立两个数据库 Create Database RiverResearch go Use RiverResearch go 然后分别为两个数据库建立模式以及表 存储过程如下Use RainbowResearch go Create Schema Rain go Create Schema Snow go Create table Rainbowresearch.Rain.Cities (id  , City varchar(200))go insert o Rainbowresearch.Rain.Cities select 1, 'Hongkong'insert o Rainbowresearch.Rain.Cities select 2, 'Tokyo'insert o Rainbowresearch.Rain.Cities select 3, 'Beijing'insert o Rainbowresearch.Rain.Cities select 4, 'Taipei'insert o Rainbowresearch.Rain.Cities select 5, 'Seoul'insert o Rainbowresearch.Rain.Cities select 6, 'Mumbai'go Create procedure Rain.DisplayCities @id as Select City from Rainbowresearch.Rain.Cities where id=@id go Create table Rainbowresearch.Snow.Cities (id , City varchar(200))go insert o Rainbowresearch.Snow.Cities select 1, 'Tokyo'insert o Rainbowresearch.Snow.Cities select 2, 'Seoul'insert o Rainbowresearch.Snow.Cities select 3, 'Moscow'insert o Rainbowresearch.Snow.Cities select 4, 'NewYork'go Create procedure Snow.DisplayCities @id as Select City from Rainbowresearch.Snow.Cities where id=@id go Use RiverResearch go Create Schema River go go Create table RiverResearch.River.Cities (id , City varchar(200))go insert o RiverResearch.River.Cities select 1, 'Hongkong'insert o RiverResearch.River.Cities select 2, 'Tokyo'insert o RiverResearch.River.Cities select 3, 'Beijing'insert o RiverResearch.River.Cities select 4, 'Taipei'insert o RiverResearch.River.Cities select 5, 'Seoul'go Create procedure River.DisplayCities @id as Select City from RiverResearch.River.Cities where id=@id Go 这里 在RainbowResearch数据库里建立了两个模式rain,snow,再分别在这两个模式下建立了city表而在riversearch数据库里也建立了个模式river 也建立了表cities就这么简单不详细表述的后 我们查询刚才建好内容select * from RiverResearch.River.Cities go select * from Rainbowresearch.Rain.Cities go select * from Rainbowresearch.Snow.Cities go 最后 我们建立同义词use RainbowResearch go create SYNONYM RiverCities for RiverResearch.River.Cities go create SYNONYM RainCities for Rainbowresearch.Rain.Cities go create SYNONYM SnowCities for Rainbowresearch.Snow.Cities go use RiverResearch go create SYNONYM RiverCities for RiverResearch.River.Cities go create SYNONYM RainCities for Rainbowresearch.Rain.Cities go create SYNONYM SnowCities for Rainbowresearch.Snow.Cities go 看到了么 简单许多了再来查询 次这次简单多了Use RiverResearch go Select * from RiverCities Select * from RainCities Select * from SnowCities Go Use RainbowResearch go Select * from RiverCities go Select * from RainCities go Select * from SnowCities go http://www.cnblogs.com/jackyrong/archive/2006/11/15/561287.html 0
相关文章
读者评论发表评论 |
|
 |
专注于互联网--专注于架构 |
最新标签 网站地图 文章索引 Rss订阅 |
