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

how insert selected column only ?

Question Posted / manoj

Answer Posted / manoj

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

Is This Answer Correct ?

11 Yes

0 No

Please Help Members By Posting Answers For Below Questions

what is raid? : Sql server database administration

715

How to list all schemas in a database?

777

How to set database to be single_user in ms sql server?

755

what is spatial nonclustered index

714

If you are given access to a SQL Server, how do you find if the SQL Instance is a named instance or a default instance?

841

Which trace flags are enabled in sql server?

663

What are the different kinds of ssrs reports?

190

How do we upgrade from SQL Server 6.5 to 7.0 and 7.0 to 2000?

1785

Tell me what do you understand by a view? What does the with check option clause for a view do?

794

Does a sql server 2005 select statement require a from?

769

What is sql azure database?

198

What is query optimizer in sql server?

729

What are database states in ms sql server?

828

What is a field name?

704

What's the information that can be stored inside a bit column?

705