SQL Server 2014 Tutorial: Create SQL Server 2014 Table in 2 ways

Here we will create a table in 2 ways :
  1. Using SSMS task
  2. Using Query Syntax
In this tutorial only give simple table with 2 data type, Varchar and Int (Integer). For more explanation about data type we will learn in other time. Watch the tutorial video carefully, if any question please write on comments below.

1. Using SQL Server Management Studio

Like shown picture above, just right click Tables on the HOSPITAL database tree, choose New Table. Then it will appear 3 columns for create new table. Just fill the columns, field/column name, data type and don't forget if you want to not allow nulls you have to type default value for your field/column. If it's done click Save Button on Toolbar or click menu File-Save.

2. Using Query Syntax

To create table using SQL Syntax, first click New Query button on Toolbar, then you type the syntax like picture above. Then just click Execute button on Toolbar or just hit F5 on keyboard.

For more step by step just watch the tutorial video on top of this tutorial or visit our channel below.
Winards Channel>>>


Comments

Post a Comment

Popular posts from this blog

Visual Studio 2013: Connecting to database SQL Server 2014 using Visual Studio 2013 form

Image
Visit our Channel In this tutorial we will create an application to testing the SQL Server 2014 database connection. We will use connection string in the connection script. This part of lesson is very important for you which want to learn database programming. Before you can manipulate the database (SQL) using Windows form, you have to know how to connect them to the database. There is several steps to connecting to the database, that is: Create Visual Studio 2013 New Project Choose Windows Form Application Add Command Button on the Form Add Module to the Project Write command script to each Object Test the application >> Create Visual Studio 2013 New Project First, you have to open Visual Studio 2013, click New Project. Choose Windows Form Application. Then will appear New Project with default 1 Form on the workspace. >> Add Command Button on the Form Add a command button control take from Tool Box to the form object. >> Add Module to th...
Read more