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-------------

Differentiate between delete and truncate.

0 Answers  

---

How to create a new table in a given schema?

0 Answers  

---

What are the security related catalog views? : sql server security

0 Answers  

---

What does top operator do?

0 Answers  

---

What happens if the update subquery returns multiple rows in ms sql server?

0 Answers  

---

What happens if we shrink log file in sql server?

0 Answers  

---

How to get a list of columns in a view using the "sp_help" stored procedure?

0 Answers  

---

Indexes are updated automatically is the full-text index also updated automatically?

0 Answers  

---

How many levels of sp nesting are possible?

0 Answers  

---

What does executeupdate return?

0 Answers  

---

What are constraints?

0 Answers  

---

How to resolve the orphan use problem? : sql server security

0 Answers  

---