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

0 Answers  

---

i want table name basis on column name.

5 Answers  

---

Why use triggers?

0 Answers  

---

How to receive returning result from a query?

0 Answers  

---

What are clustered and non-clustered index?

0 Answers  

---

How you provide security to cube? : sql server analysis services, ssas

0 Answers  

---

What are the different types of collation sensitivity?

0 Answers  

---

How do you start single user mode in clustered installations?

0 Answers  

---

what is the difference detween pairwise comparison subquary and non pairwise comparison subquary?

2 Answers  

---

How to write a query with a left outer join in ms sql server?

0 Answers  

---

Wht is the difference between stored procedure and trigger

6 Answers   HCL, TCS,

---

How to run queries with sql server management studio express?

0 Answers  

---