Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
mahesh_bote
Constraint Violating Yak Guru
298 Posts |
 Posted - 2007-05-28 : 07:56:30
|
| refering tables in two part notation means what?can anybody tell me, what is Two Part Notation? or does it means adding alias to the table following by the table name?Thanks in advance,Mahesh |
|
|
harsh_athalye
Master Smack Fu Yak Hacker
5581 Posts |
Posted - 2007-05-28 : 08:20:33
|
| Normally there are four parts to refer to a database object.ServerName.DatabaseName.OwnerName.ObjectNameSo I guess the two-part naming refers to Ownername.tablename, like dbo.someTableHarsh AthalyeIndia."The IMPOSSIBLE is often UNTRIED" |
 |
|
|
spirit1
Cybernetic Yak Master
11752 Posts |
Posted - 2007-05-28 : 08:20:52
|
| 4 part:serverName.dbName.schemaName.tableName3 part:dbName.schemaName.tableName2 part:schemaName.tableName1 part:tableName_______________________________________________Causing trouble since 1980blog: http://weblogs.sqlteam.com/mladenp |
|
|
|
|
|
|
Two part notation