How to create table in sql server 2008

By
Advertisement
In this article i am going to explain about how to create table in sql server 2008.

"Create Table" Statement is uesd to create table in sql server. In sql server tables are organised as rows and columns.And each column will have name and the datatype it accepts. So creating table in sql server we need to create columns with datatype.

Below is the syntax to create table in sql server 2008.

CREATE TABLE table_name
(
column_name1 data_type(size),
column_name2 data_type(size),
column_name3 data_type(size),
....
);

Below is the script to create student table

CREATE TABLE StudentMaster
(
Name VARCHAR(50),
Standard INT,
Section CHAR(5)
)

After creating table you can check it in the object explorer.
Create Table in sql server 2008



After creating table we can insert the record in the table in the below format

INSERT INTO StudentMaster(Name,Standard,Section)
VALUES('Kannadasan','12','A')

INSERT INTO StudentMaster(Name,Standard,Section)
VALUES('Xavier','12','B')

INSERT INTO StudentMaster(Name,Standard,Section)
VALUES('Ram Kumar','12','c')

Now to check the inserted columns you can run the select statement like below.

SELECT * FROM StudentMaster

The output will be like below

Output of the select * query after inserting into table






You can also select particular column alone.. To select particular columns alone you need to mention the column name in the select query. Below is the used to select only Name and Section.

SELECT Name,Section FROM StudentMaster

The sample output will look like
Output of the select query with specific columns





And also not only we can select particular columns we can insert particular columns alone. To insert Name and Standard alone we can make use of the below query. But the columns which you omit while inserting any record in the table should be nullable column or it should accept some default values.

INSERT INTO StudentMaster(Name,Standard)
VALUES('Tamil','12')

INSERT INTO StudentMaster(Name,Standard)
VALUES('Kavi','12')

INSERT INTO StudentMaster(Name,Standard)
VALUES('Saiva','12')

Now if you check the output it will look like below.

Output of the select query with all columns










If you have any doubt please post it in comment or mail us. If you like this article you can share it with your friends. For regular update like our facebook page.

0 comments:

Post a Comment

Online Casino