how can ur insert the emp table
Answers were Sorted based on User's Feedback
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 >)
Is This Answer Correct ? | 36 Yes | 0 No |
Answer / ammuk221
insert into emp values(serialno,'emp
name','hiredate',emppost,salary,deptno,commission);
Is This Answer Correct ? | 12 Yes | 7 No |
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-------------
Is This Answer Correct ? | 0 Yes | 0 No |
how to restart sql server in single user mode? How to start sql server in minimal configuration mode? : Sql server database administration
What is nolock?
Explain system functions or built-in functions? What are different types of system functions?
What are data resources?
How to create a dml trigger using create trigger statements?
In which year relase the 7.0& 2000 & 2005?
What is an expensive query?
Explain what is the main purpose of having conversation group?
What is store procedure? How do they work? When do you use?
How the data stores in a page?
What is the basic functions for master, msdb, tempdb databases?
What are the different types of sql server replication? : sql server replication