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 happens if we shrink log file in sql server?

603


Give the query of getting last two records from the table in SQL SERVER?

631


what are cursors? : Sql server database administration

616


Explain the categories of stored procedure?

611


Distinguish between commit and rollback?

619






Explain transaction server distributed transaction?

595


What is ms sql server reporting services?

616


Can we check locks in database? If so, how can we do this lock check?

610


What is the syntax for encrypting a column in SQL Server?

649


tell me what is blocking and how would you troubleshoot it? : Sql server database administration

566


What is an sql server agent?

628


What is delete query?

606


Is t sql the same as sql server?

602


List down some advantages of sql stored procedure?

638


How can I know what locks are running on which resource?

604