블로그 이미지
불쥐의 눈으로 본세상 ㏈ª ☞ β┖υΕJini.κR

카테고리

분류 전체보기 (234)
By β┖υΕJini (131)
㏈ª By β┖υΕJini (103)
Total278,061
Today33
Yesterday38

'Multiple Insert Rows'에 해당되는 글 1건

  1. 2009.10.09 Multiple Insert Rows

사용자 삽입 이미지


Multiple Insert Rows

SQL Server 2008 supports the option of inserting multiple records in one statement. Each row of data is followed by a comma until reaching the last row where the INSERT command is completed like normal.


CREATE TABLE Customers
( CustID VARCHAR(20), CustName VARCHAR(20)
)





INSERT INTO Customers (CustID, CustName) VALUES ('Cust1', 'Smith Company'), ('Cust2', 'Perform Company'), ('Cust3', 'Test Inc');

Other version of SQL Server require a separate statement to be executed for each record insert.

Posted by ㏈ª ☞ β┖υΕJini.κR