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

how insert selected column only ?

Question Posted / srinivas

Answer Posted / srinivas

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

Is This Answer Correct ?

1 Yes

0 No

Please Help Members By Posting Answers For Below Questions

What is function of ROLLUP ?

1083

Why use “nolock” in sql server?

1058

Define outer join?

997

What new data source types were added in ssrs 2014?

160

How to convert a table data in XML format in sql server?

2540

How to apply cascading referential integrity in place of triggers?

1034

What is change data capture (cdc) in sql server 2008?

1024

How many joins in sql server?

957

When to use null data driven subscription?

206

What is set nocount on?

938

John exports information periodically from a microsoft sql server database to an oracle database what is the best way to do this?

942

In what three ways is the return statement used in a stored procedure?

1008

Explain boyce and codd normal form(bcnf)?

958

Can we shrink data file in sql server?

1049

Explain how would you store your query in an SSRS report or a Database server?

128