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

Is port 1433 secure?

536


What is dbcc?

731


How can you find out which stored procedures are recompiling?

512


How to create sub reports?

192


Due to some maintenance being done, the sql server on a failover cluster needs to be brought down. How do you bring the sql server down?

862






What are the advantages of stored procedure in sql server?

463


Explain different forms of normalization?

526


How to write a query with a full outer join in ms sql server?

558


how can you find out if the current user is a member of the specified microsoft® windows nt® group or microsoft sql server™ role? : Sql server administration

566


What is the difference between a fill factor of 100 and 0?

528


What is normalization of database? What are its benefits?

515


Can we deploy SSRS reports on our personal website?

123


Why truncate is ddl command?

512


What is a covering index?

530


Explain transaction isolation levels in sql server?

545