面试宝典

SQL SERVER 数据库名称..两个点这是什么意思?


Home»SQL Server 2005»T-SQL (SS2K5)»What does 2 periods after DB name mean? What does 2 periods after DB name mean? databasename.schemaname.tablename.fieldname - standard 4 part naming. When working with MSAccess DB (for example) you are using: databasename..tablename.fieldname since MSAccess does not have schemas.

SQL SERVER 数据库名称..两个点这是什么意思?

SQL SERVER 数据库名称.. 这是什么意思?

(1)
select *
from WellyTest.dbo.testTable

(2)
select *
from [WellyTest]..[testTable]

sql2005 下使用(1)总提示找不到表。。。用(2)则是可以的。

前者制定了所有者
后者是当前登陆的默认角色?