Services
Technology Web App Development Mobile App Development Windows App Development Database Development UI/UX Development Cloud Development SEO Digital Marketing Guest Posting Content Writing Artificial Intelligence Data Science ERP Development CRM Development CMS Development LMS Development Business Listing Blockchain Technology Startup Promotion AI Tools Integration
Products
Data Converter Cleaner TUC - Unit Converter Import Export Survey Manager Tweet Controller
Developer
Article Blog Forum Interview Beginner News Startup Quiz
Users
Career
Apply Job Internship
Pricing
Login Sign Up Get a Quote

interview

home / developersection / interviews / basic operation create , insert, update and delete in sql.
Ask Question
Abhishek Srivasatava
Abhishek Srivasatava

Employee

Message

1 Answers

Abhishek Srivasatava
Abhishek Srivasatava 27 Sep 2016
Report Abuse

How to create table?

 

Table can be form by 2 ways:

 

Programming method and manual method.

 

Programming Method

 

  Example : CREATE TABLE EE_EMPL_CAT
(
PRSN_INTN_ID  int
NOT NULL PRIMARY KEY ,
EMPL_STAT_CD char(20)  NOT NULL ,
NAME  char(10,
REFERENCE_ID int,
);

 

2nd method is the manual method. You need to follow following step. 

Under database -> under Table section right click on table point to new table.

Name the Column Name like ee_intn_id etc, datatype, check or unchecked the ‘Allow Null’ column. 


Save the table.

For putting constraint on your table read this Cluster and non-cluster index in SQL and Different types of Constraints in SQL.

 

How to insert data into the table?

 

Below is the syntax to insert.

INSERT INTO EE_EMPL_CAT1 (PRSN_INTN_ID, [EMPL_STAT_CD],[NAME],REFERENCE_ID)
    VALUES (1199667, 'ACTIVE', 'DAVID',159978)

 

How to Update data into the table?

 

Below is the syntax to Update.

 
UPDATE EE_EMPL_CAT1
    SET NAME = 'SMITH'
    WHERE PRSN_INTN_ID = 1199668


How to delete the data from the table?

Below is the syntax to Delete:

 DELETE FROM EE_EMPL_CAT1
    WHERE NAME = 'DAVID'
    
MindStick Training