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 are the different type of replication in sql server?
Write SQL queries on Self Join and Inner Join.
Is there any difference between the primary key and unique key?
What are the types of backup and tell me the difference between full and differential backup?
What are the differences between local and global temporary tables?
create table with fields ID, reserved_by,res_date res_date is datefield like 2010-03-09 00:00:00.000 from 2005 to 2006 any date assume based on res_date need to slect table and display based on month (full jan details in database irrespective of date and year
Why do we use trigger?
how do u do Performance tunning ?
1 Answers Infodat Technologies, Satyam,
What does it mean to normalize data?
Which trace flags are enabled in sql server?
What are acid properties of transaction?
What is mapping schema?