How do I insert data into a table in my MSSQL database?

Website software such as WordPress or Joomla that are used to create features such as blogs, forums and content management systems will automatically insert the data into the required tables in your database. If your needs require you to enter additional data, please do the following:

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 10

Start by logging in to your 123 Reg Control Panel.

 

Step 2 of 10

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.

Manage Shared Web Hosting

 

Step 3 of 10

This will show you an overview of your current hosting packages. Click Manage for the account you wish to use.

Manage Legacy hosting

 

Step 4 of 10

On the next page, select Manage for the domain you wish to update.

Manage hosting domain

 

Step 5 of 10

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

Step 6 of 10

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

 

Step 7 of 10

Click on the Tables option in the Database menu.

Step 8 of 10

Select the Tables that you want to insert data into.

Step 9 of 10

Click on the View/edit data button.

Step 10 of 10
  • Enter the required data into the columns and press the Insert to continue.

Your data will now be added to the table.

Related Support Material:

  1. How do I import a MySQL database with SSH?
  2. How do I find my database hostname?
  3. How do I update the database password within my configuration file?
  4. How do I resolve ‘Error establishing a database connection’?
  5. How do I request my personal data that’s been collected for my SSL certificate?
  6. Using Plesk Migrator to move data between 123 Reg Virtual Private Servers