Multiple Insert Rows1 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'), .. 2009. 10. 9. 이전 1 다음
