how can ur insert the emp table

Answer Posted / 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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is the difference between writing data to mirrored drives versus raid5 drives

688


What is the sql case statement used for?

755


What are the differences between decimal and float in ms sql server?

749


What is the need for group functions in sql?

743


How to find the source of a table in sql server?

709






Define Joins?

779


What is function of ROLLUP ?

801


List some of the rules that apply to creating and using a ‘view’

673


What is Transparent Data Encryption?

731


What is the tcp/ip port on which sql server runs?

746


What are the advantages of paper records?

723


What is a partitioned view?

768


How to verify a login name with sqlcmd tool?

789


How to select true false based on column value in sql server?

708


How can we improve performance by using SQL Server profiler?

740