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
Today
    Last 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