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 |
|
icw
Constraint Violating Yak Guru
378 Posts |
 Posted - 2009-01-08 : 00:39:20
|
| This may seem silly but I want to clear this up in my head.If I am using Query Analyzer to create a query, I can drag a field from the explorer view onto the query pane and when it appears it appears as dbo.columnname. The query works fine if I also remove the dbo. and just use columnname.Can anyone tell me when or why i would need to use the dbo.columnname instead of just the column name.(ps - i know it stands for database owner - but that doesn't make it any clearer)TIA |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
icw
Constraint Violating Yak Guru
378 Posts |
Posted - 2009-01-08 : 01:26:35
|
| Thanks tkizer,are you saying that my queries will perform better if i use the two part naming convention? |
 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
icw
Constraint Violating Yak Guru
378 Posts |
Posted - 2009-01-08 : 03:13:40
|
| thanks a lot for the explanation |
|
|
|
|
|
|
Can I ask a silly question about dbo