Basic operation CREATE , INSERT, UPDATE and DELETE in SQL.

Question

Abhishek Srivasatava · Answer

How to create table?
and 
Table can be form by 2 ways:
and 
Programming method and manual method.
and 
Programming Method
and 
and Example : CREATE TABLE EE_EMPL_CAT(
PRSN_INTN_IDand int
NOT NULL PRIMARY KEY ,EMPL_STAT_CD char(20)and NOT NULL ,NAMEand char(10,REFERENCE_ID int,);
and 
2nd method is the manual method. You need to follow following step.and Under database -andgt; under Table section right click on table point to new table.Name the Column Name like ee_intn_id etc, datatype, check orand uncheckedand the ‘Allow Null’ column.and Save the table.For puttingand constraintand on your table read thisand Cluster and non-cluster index in SQLand andand Different types of Constraints in SQL.
and 
How to insert data into the table?
and 
Below is the syntax to insert.
INSERT INTO EE_EMPL_CAT1 (PRSN_INTN_ID, [EMPL_STAT_CD],[NAME],REFERENCE_ID)and and and VALUES (1199667, 'ACTIVE', 'DAVID',159978)
and 
How to Update data into the table?
and 
Below is the syntax to Update.
and UPDATE EE_EMPL_CAT1and and and SET NAME = 'SMITH'and and and WHERE PRSN_INTN_ID = 1199668
How to delete the data from the table?
Below is the syntax to Delete:
and DELETE FROM EE_EMPL_CAT1and and and WHERE NAME = 'DAVID'and and and

interview

Basic operation CREATE , INSERT, UPDATE and DELETE in SQL.

Abhishek Srivasatava

1 Answers

Liked By