How do I query my MSSQL database?

If you need to retrieve specific data from your database, you can create a query to recover the desired data. For example, if you were running a forum, you could create a query to view all of the users that have posted a certain amount of times, or find a list of users that have posted within the last week.

Please note: MSSQL databases are no longer available on any Web Hosting plans bought after July 2020 or Premium Hosting plans bought after August 2020

Step 1 of 4

Click on the MSSQL Database link in the Web Tools section of your hosting control panel.

Step 2 of 4

In the Manage Databases section press the Manage button to access your database administration area.

Step 3 of 4

Click on the Query button, this is located in the menu on the left hand side of the screen.

Step 4 of 4

Enter your query into the box provided and click on the Execute query button.

Related Support Material:

  1. How do I remove database tables?
  2. How do I resolve ‘Error establishing a database connection’?
  3. How do I update my WordPress database connection string?
  4. How to export a database on my Windows Hosting package?
  5. How to create a database on my Windows Hosting package?
  6. Create a new WordPress admin user in the database