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 |
|
mbevon
Starting Member
41 Posts |
 Posted - 2002-05-14 : 14:34:43
|
| I'm accessing the server with the domain name STATISTICSI'm new to SQL 2000, I'm in the Query Analyser trying the following.SELECT *FROM BB1999CIT'S NOT WORKING, THIS IS HOW I'M SEEING THE TABLESTATISTICS\marlon_b.BB1999Ci'M MARLON_BHOW DO I RUN THE QUERY?THANKS |
|
|
Kevin Snow
Posting Yak Master
149 Posts |
Posted - 2002-05-14 : 14:45:38
|
| Make sure you are using the correct database (as shown in the dropdown selection box at the top of Query Analyzer) If there is any question, try the three part name-Select * from [databasename].dbo.BB1999CIf this still doesn't find it, try to locate the table. sp_tables will give a list of all tables found in the current database. If it's not in the list, then the table isn't in the database.Other than that, your syntax is correct. If there is a table BB199C, AND you have access rights and are currently in the correct database, that statement should return the expected record set.If not, please provide any error messages accompanying the failure. |
 |
|
|
|
|
|
Running query