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

How much does sql server 2016 cost?

546


Tell me about builtinadministrator?

572


What are the various editions of sql server 2017 that are available in the market?

512


What is difference between commit and rollback when used in transactions?

510


How many types of objects are there?

513






What is the use of sql profiler in sql server 2012?

525


Which is the latest version of sql server and when it is released?

563


What are the advantages of using stored procedures in sql server?

520


What is the return type of executeupdate ()?

535


explain different types of cursors? : Sql server database administration

575


What is outer join in sql server joins?

606


What are the disadvantages of merge replication?

789


Explain magic tables in sql server?

561


What is the full form of ddl?

519


What is a primary index?

540