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 |
|
zhshqzyc
Posting Yak Master
240 Posts |
 Posted - 2008-08-01 : 11:47:36
|
| [code]INSERT INTO P..CG ([ID],[OBJ_ID]) VALUES('6','8')[/code]What does it mean by ".."?Thanks |
|
|
jezemine
Master Smack Fu Yak Hacker
2886 Posts |
Posted - 2008-08-01 : 11:54:50
|
it's shorthand for when you don't want to include the schema/owner name. If CG is in the dbo schema, it's equivalent to this:P.dbo.CGI think it's better to always include the schema name so there is no ambiguity.
elsasoft.org |
 |
|
|
tfountain
Constraint Violating Yak Guru
491 Posts |
Posted - 2008-08-01 : 11:56:12
|
| Review the syntax for qualifying object names in the database in the BOL. But basically the qualifier format is:[server].[database].[schema].[object] where schema is not required and will be determined based on certain rules. |
|
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2008-08-04 : 04:50:15
|
quote:
Originally posted by zhshqzyc
INSERT INTO P..CG ([ID],[OBJ_ID]) VALUES('6','8')What does it mean by ".."?Thanks
[ ]".." is as confusing as your thread title[/]MadhivananFailing to plan is Planning to fail |
|
|
|
|
|
|
..