syntex of insert

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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is public role in sql server?

529


you have separate development and production systems you want to move a copy of a development database into production to do this, you do a backup on the development system and restore to the production system after a few minutes, you begin getting calls from several customers saying that they are denied access to the system why? : Sql server administration

546


If you lose rights to your sql server instance what are the options to connect to sql server instance? : sql server security

530


how would you improve etl (extract, transform, load) throughput?

530


What is ms sql server index?

557






What is rtm version in sql server?

519


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

563


What do you understand by check constraint in sql server?

476


What do you mean by collation recursive stored procedure?

583


what is a transaction? : Sql server database administration

469


Can you explain important index characteristics?

518


Difference between group by clause and having clause in SQL?

561


please differentiate between delete and truncate?

549


What is the purpose of update statistics and scope_identity() function?

595


How do I trace a query in sql server?

536