how insert selected column only ?

Answer Posted / srinivas

insert into <table_name> ( <col1> ,<col3>) values ( val1,val2)

Is This Answer Correct ?    1 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is plan freezing?

722


How to enter comments in transact-sql statements?

707


What is the difference between nvl and nvl2?

709


What is difference between primary key and foreign key?

644


What is key attribute?

693






Explain features of analysis services?

687


What is a rownum?

671


If a table does not have a unique index, can a cursor be opened on it?

661


Write a program to fetch first 10 records from a file?

755


Explain in brief how sql server enhances scalability of the database system?

685


Explain primary key, foreign key and unique key?

734


What types of replication are supported in sql server?

733


Why do we use trigger?

707


What is normalization of database?

762


What is usually the first word in a sql query?

808