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.
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
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
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.
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.
Comments
Post a Comment