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 the openxml statement in sql server?

0 Answers  

---

How do I connect to sql server database?

0 Answers  

---

what is the difference between Delete and Truncate command in SQL

0 Answers   BirlaSoft,

---

Tell about MOM Tool(Microsoft Operator Manager)?

0 Answers  

---

How to Run a Query on a Remote SQL Server?

2 Answers  

---

What is the difference between views and stored procedures? Can we have input parameters for views?

6 Answers  

---

What is replace and stuff function in sql server?

0 Answers  

---

What are the types of containers in ssis?

0 Answers  

---

Advantages and Disadvantages of Cursor?

15 Answers   Polytechnic, TCS, Zenith,

---

Can we create a clustered index on composite primary key.

3 Answers   IGT,

---

Define candidate key, alternate key, and composite key.

0 Answers  

---

How to count rows with the count(*) function in ms sql server?

0 Answers  

---