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

카테고리

분류 전체보기 (234)
By β┖υΕJini (131)
㏈ª By β┖υΕJini (103)
Total271,801
Today15
Yesterday27

사용자 삽입 이미지


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