insert into tablename (col1,col2,........) values (val1,val2,........)

syntex of insert

Question Posted / mahathi

Answer Posted / mahathi

insert into tablename (col1,col2,........) values
(val1,val2,........)

Is This Answer Correct ?

9 Yes

1 No

Please Help Members By Posting Answers For Below Questions

What method is used by the Command classes to execute SQL statements that return single values?

1044

What does <> symbol mean?

949

How can we delete Duplicate row in table?

1038

How to truncate the log in sql server 2012? : sql server database administration

1256

Types of Authentications in Sql Server? How user gets authenticated through windows authentication?

1029

How to divide query output into multiple groups with the group by clause in ms sql server?

1011

whats the maximum size of view state??

2175

Does server sql treat char as a variable-length or fixed-length column?

981

How to convert binary strings into integers in ms sql server?

1002

What number sorts of privileges are accessible in sql?

1014

Is a null value equal to anything? Can a space in a column be considered a null value? Why or why not?

1049

Explain indexed views and partitioned view with their syntax.

1120

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

1017

How to choose all records from the table?

1039

How to find the service pack installed? : sql server database administration

1008