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
Start by logging in to your 123 Reg Control Panel.
From there, select Web Hosting or Premium Hosting within the ‘Manage active products’ section, depending on which product you wish to use.
Next, select Manage opposite the ‘(bought before XX/XX/XX)’ option.
This will show you an overview of your current hosting packages. Click Manage for the account you wish to use.
On the next page, select Manage for the domain you wish to update.
Click on the MSSQL Database link in the Web Tools section of your hosting control panel.
In the Manage Databases section press the Manage button to access your database administration area.
Click on the Query button, this is located in the menu on the left hand side of the screen.
Enter your query into the box provided and click on the Execute query button.