How to install Microsoft SQL Server Studio Express
Microsoft SQL Server Studio Express can be downloaded free of charge from this link. If you are using Windows 32 bit download the file SQLServer2005_SSMSEE.msi and for Windows 64 bit download SQLServer2005_SSMSEE_x64.msi.
How to connect to the SQL server from your hosting/network provider
- Open SQL Server Studio Express
- For the “Server name” fill in the IP-address of the remote server.
How to create a table
- Select your database on the server
- Click on Tables
- Click with the right mouse button, on the right side window and from the pop up menu select New Table ...
- Create columns and the set the data type
varchar is a variable length which cannot hold unicode characters, it uses only one byte storage per character.
nchar or ntext is fixed-length which can hold unicode characters, it uses two bytes storage per character.
nchar or ntext is fixed-length which can hold unicode characters, it uses two bytes storage per character.
- When you're done, click onthe Save button
on the top of the page or type Ctrl+S.
The last empty field is not saved. Do not worry about it. It only lets you know the position of your cursor. - Enter a name for your new table
That's it. The table has been created on the remote server and can be used to add, display, edit or remove records using ASP.Net, classic ASP and any other programming language.
How to create a unique identifier and automatically increase the number
If you want to create a unique identifier and automatically increase the number as you add new records, open the Column Properties and change the settings as shown in the example below:
Create a table with a query
Another quick way to create a table is by executing a query.
- Select the database on the server
- Click on New Query
- Type the SQL query for the new table:
- Click on the button Execute