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 are sql server procedures?

0 Answers  

---

What is the user of Primary key?

0 Answers  

---

Explain the properties of sub-query in sql server?

0 Answers  

---

What are examples of triggers?

0 Answers  

---

How to get all stored procedures in sql server?

0 Answers  

---

What is difference between order by and group by?

0 Answers  

---

what is diffence between replicaion and logshipping?

1 Answers  

---

how to do partition in sqlserver

0 Answers   TCS,

---

What is the sql profiler?

0 Answers  

---

What is a trace frag? Where do we use it?

0 Answers  

---

Do you know the policy based administration feature of sql server 2008?

0 Answers  

---

How can your resolve deadlocks?

4 Answers   IBM, IMS, Iron Mountain, NuWare,

---