TECHNOLOGIES
FORUMS
JOBS
BOOKS
EVENTS
INTERVIEWS
Live
MORE
LEARN
Training
CAREER
MEMBERS
VIDEOS
NEWS
BLOGS
Sign Up
Login
No unread comment.
View All Comments
No unread message.
View All Messages
No unread notification.
View All Notifications
C# Corner
Post
An Article
A Blog
A News
A Video
An EBook
An Interview Question
Ask Question
How to Create a Database in SQL
Krishna Rajput Singh
May 13
2015
Code
1.2
k
0
1
facebook
twitter
linkedIn
Reddit
WhatsApp
Email
Bookmark
expand
CREATE DATABASE OFFI
CREATE
DATABASE
OFFICE;
USE OFFICE;
CREATE
TABLE
Employees
(
Employee_id
varchar
(10)
primary
key
not
null
,
Employee_Name
char
(20)
not
null
,
Employee_Address
varchar
(30)
not
null
,
Employee_Mobileno
varchar
(10)
not
null
);
select
*
from
Employees
insert
into
Employees
values
(
'K112'
,
'Krishna'
,
'Mahipalpur New Delhi-37'
,9540434299);
insert
into
Employees
values
(
'S211'
,
'Surbhi'
,
'Palam new delhi'
);
insert
into
Employees
values
(
'v311'
,
'mansi'
,
'palam new delhi'
);
alter
table
employees
ADD
Employee_mobileno
varchar
(10);
update
Employees
set
Employee_Mobileno=9540434299
where
Employee_id=
'K111'
;
SQL SERVER
Create table in SQL
Insert values in Table