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

Please illustrate physical database architecture? : SQL Server Architecture

0 Answers  

---

What is difference between clustered index and non clustered index?

0 Answers  

---

user defined datatypes

1 Answers   Wipro,

---

what is index seek and index scan?

2 Answers  

---

If you are working on a SQL database and if suddenly a developer changes the code and your queries results start giving errors,how will you check using a T-SQL query (on system tables) that what has changed in the database.

2 Answers   Microsoft,

---

Explain magic tables in sql server?

0 Answers  

---

WHAT IS THE DIFFERENCE BETWEEN CANDIDATE KEY ,COMPOSITE KEY AND PRIMARY KEY. THAN U.

1 Answers   Synergy,

---

How can i change the column name.

13 Answers   HCL, Yardi Software,

---

What is single-user mode?

0 Answers  

---

Explain a differential backup?

0 Answers  

---

Without Using Cursors , How to Select the Selected row??

3 Answers   CarrizalSoft Technologies, Wipro,

---

How to create Clustered Primary Key to table?

2 Answers  

---