Answered Questions

  • Database Access

    Can we do database operations without using any of the objects?This was an interview question

    Star Read Best Answer

    Editorial / Best Answer


    • Member Since Jun-2010 | Jun 15th, 2010


    1. SQLCMD is the utility which supports command line interface to perform SQL operations. Output data in xml file & do opertions!

    2. Alternate way to fetch data is enabling SQL server option which allows to provides data on web in XML format (IDK where it is but yes it was there in SQL 2k). Its data on http so you can read & process it just like a web service but cant perform operations.

    I am sure there are other ways too! like

    1. Create own database format other then SQL

    2. Set up API in other application to fetch/process data in other application & set up custom components to store/process them.