Answer / kumar

Alredy We are having the emp table in our database at the
time only we can insert the data otherwise not possible.

We can insert the data into emp table into 2 ways by using insert command.Two syntax of insert command given below

1.insert into tablename values(<values list>)
2.insert into tablename(<column list>) values(<spcified column values >)

Answer / ammuk221

insert into emp values(serialno,'emp
name','hiredate',emppost,salary,deptno,commission);

Answer / madhav

BY USING 'ON THE FLY TABLES'
CREAT TABLE EMPLOYEE AS SELECT * FROM EMP WHERE 1=2;
(FOR TABLE STRUCTURE)
-----TO INSERT THE EMP TABLE VALUES-------
INSERT INTO EMPLOYEE(SELECT * FROM EMP);
(INSERT THE EMP TABLE DATA)
SELECT * FROM EMPLOYEE;

-----------ALL THE BEST-------------

Write a SQL query to make a column as unique?

0 Answers   Cap Gemini,

---

What are the properties of the transaction?

0 Answers  

---

Explain what are commit and rollback in sql?

0 Answers  

---

What is clustered index

0 Answers  

---

What are the purpose of Normalisation?

0 Answers   HCL,

---

How to edit table in sql server 2017?

0 Answers  

---

how many no of arguments can be passed in procedures and functions

1 Answers   ABC,

---

How do you find value of first column before inserting value into the second column in the same table for checking that second column must have different value than first column.

2 Answers   L&T,

---

Why Master database is required?

0 Answers   Abacus,

---

What are the difference between clustered and a non-clustered index?

0 Answers  

---

1.can we set the more than 1 primary keys for a table? 2.please give me the difference between Cluster Index and non-Clustered Index 3.can we use query like this "Select * from Table1,Table2;"

8 Answers  

---

What is difference between restoration and recovery in SQLServer?

3 Answers   Microsoft,

---