how insert selected column only ?

Answer Posted / manoj

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

Is This Answer Correct ?    11 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How to fine-tune reports?

151


What is proper subset of candidate key?

555


Is it possible in sql table to have more than one foreign key?

610


What are the grouping functions?

525


What are number line correlation administrators will use while working with a subquery?

623






what is the difference in login security modes between v6.5 and 7.0? : Sql server database administration

647


Data is not being delivered to subscribers, what can be the possible reasons? : sql server replication

539


Can you explain about buffer cash and log cache in sql server?

498


What are the steps you can take to avoid “deadlocks”?

521


What are the advantages dts has over bcp?

525


What is the difference between grant and with grant while giving permissions to the user?

506


Can I run multiple instances of sql server 2000 at the same time on one computer?

596


What are the differences between lost updates and uncommitted dependencies?

539


How to create user messages with print statements in ms sql server?

588


What is db stored procedure?

467