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 |
|
lamujerdetuhermano10
Yak Posting Veteran
75 Posts |
 Posted - 2008-08-27 : 19:32:06
|
| how do u write a select statement using the db name on sql server 2005? looks like its not workingselect * from hardware_I18_SVO_25AUG08.client.client where clientid ='12' |
|
|
jezemine
Master Smack Fu Yak Hacker
2886 Posts |
Posted - 2008-08-27 : 19:39:14
|
probably this:select * from hardware_I18_SVO_25AUG08.dbo.client where clientid ='12'
elsasoft.org |
 |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-08-27 : 20:52:09
|
quote:
Originally posted by jezemine
probably this:select * from [hardware_I18_SVO_25AUG08].dbo.client where clientid ='12'
elsasoft.org
|
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
|
|
|
db name in front not working