INSERT INTO table[(cloumn [,cloumn...])] VALUES (value[,value...]); wit

syntex of insert

Question Posted / gajanan.waghode

Answer Posted / gajanan.waghode

INSERT INTO table[(cloumn [,cloumn...])]
VALUES (value[,value...]);

with this syntax only one row is inserted at a time.

Is This Answer Correct ?

0 Yes

0 No

Please Help Members By Posting Answers For Below Questions

How to generate create function script on an existing function?

1117

Please illustrate physical database architecture? : SQL Server Architecture

988

What do you mean by sql server 2005 express management tools?

1307

What is delete query?

940

What are the different sql server versions?

980

What is the difference between a local and a global temporary table?

1121

Can coalesce return null?

1016

Can you name a few encryption mechanisms in sql server?

942

How to configure and test odbc dsn settings?

1160

Give me any three differences between Truncate and Delete.

1107

What is a fill factor?

1087

What are the different types of collation sensitivity?

1125

How do you create an execution plan?

948

Why use cursor in sql server?

1081

what is a deadlock? : Sql server database administration

1066