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 |
What is deadlock and how to avoid the deadlocks.
What is data compression? : sql server database administration
Explain intellisense for query editing
What is tcl in sql server?
Write a query to delete duplicate records in SQL SERVER
can a table be moved to different filegroup? : Sql server administration
what are the Prerequisites for Replication?
Can group by be used without aggregate functions?
How to get nth highest salary from employee table.
What is Transparent Data Encryption?
How to convert numeric values to integers in ms sql server?
What is the difference between primary key and unique constraints?