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 |
|
Sun Foster
Aged Yak Warrior
515 Posts |
 Posted - 2005-06-01 : 16:26:30
|
| If I run this sentence, got error:select OrderServer.OrderDB.dbo.tblOrder.OrderID from OrderServer.OrderDB.dbo.tblOrder, but got error said, prefix over 3.How fix? Is it too long? |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2005-06-01 : 16:33:50
|
| It's not a sentence, it's a query.select OrderID from OrderServer.OrderDB.dbo.tblOrderTara |
 |
|
|
AndyB13
Aged Yak Warrior
583 Posts |
Posted - 2005-06-01 : 19:36:32
|
Duplicate post just worded differently.I and Tara have already answered this question!Look up aliases in BOL  [url]http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=50523[/url]Beauty is in the eyes of the beerholder  |
|
|
|
|
|
|
linked server