SQL Server 2014 Tutorial: How to create database, table using SQL Server 2014 Management Studio


Before create a database, you have to decide the following :
Database name
Database file path

We will create a database
Database name:
HOSPITAL
Database file path
D:\HOSPITAL

In this tutorial we will learn how to create a SQL Server 2014 database  in an easy way. Watch the tutorial video carefully, if any question please write on comments below.

Comments

Post a Comment

Popular posts from this blog

SQL Server 2014: Connecting to SQL Server database using SQL Server Management Studio

Image
In this tutorial we will learn how to connect a SQL Server database using SSMS (SQL Server Management Studio). SSMS is a tool to control directly to the database using menu and queries. Just be careful if you use this tool because you can update, insert and remove data in the database. If you want to use this tool you should backup the database first. So if you make mistake you just restore your database backup, it save. This tutorial is intended for basic knowledge about SQL Server 2014 client user. Enjoy the video of course. :)
Read more

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

Image
Visit Our Channel Here we will create a table in 2 ways : Using SSMS task 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...
Read more