C# Tutorials and offshore development in India
    Tutorials   Resources   Forum   Reviews   Communities   Interview   Jobs   Projects   Training   Your Ad Here    
Silverlight Games | Mentor | Code Converter | Articles | Code Factory | Computer Jokes | Members | Peer Appraisal | IT Companies | Bookmarks | Polls | Revenue Sharing | Lobby | Gift Shop |


Prizes & Awards
My Profile



Active Members
TodayLast 7 Days more...






Forums » .NET » SQL Server »

SqlServer


Posted Date: 30 Sep 2008      Posted By: kalaimanichozhan      Member Level: Gold     Points: 1   Responses: 2



In sqlserver 2000(Query Analyzer) we use..
use <databasename>
to access tables present in that database.

If there is any query to end or close database.





Responses

Author: sathish    30 Sep 2008Member Level: SilverRating:     Points: -20

Hi try this

To Select Table in the Other DB

use

<databasename>..tablename

you no need to go to that DB

Sathish.s
Pothanur



Author: Vidhya    01 Oct 2008Member Level: GoldRating: 3 out of 53 out of 53 out of 5     Points: 3

Hi,

To close a database connection use this statement:

CLOSE DATABASE....

Hope this helps you!

Regards,
Vidhya



Post Reply

 This thread is locked for new responses. Please post your comments and questions as a separate thread.
If required, refer to the URL of this page in your new post.


Next : Date
Previous : SQL server backup files
Return to Discussion Forum
Post New Message
Category: SQL Server

Related Messages



dotNet Slackers

About Us    Contact Us    Privacy Policy    Terms Of Use