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

What is your recommendation for a query running very slow? : sql server database administration

0 Answers  

---

Describe in brief databases and sql server databases architecture.

0 Answers  

---

How to restart SQL Server in single user mode? How to start SQL Server in minimal configuration mode?

2 Answers  

---

What is the difference between functions and stored procedures?

0 Answers   Accenture,

---

What are the steps you must follow to hide sql server instances?

0 Answers  

---

What are pages and extents? : SQL Server Architecture

0 Answers  

---

What are the differences between union, intersect, and minus operators?

0 Answers  

---

How to find related tables in sql server?

0 Answers  

---

Relational calculus is what type of language?

0 Answers   HCL,

---

What is lock escalation? : sql server database administration

0 Answers  

---

List the different normalization forms?

0 Answers  

---

Define DML and DCL statements?

1 Answers   Hexaware, NIIT,

---