SQL Server 2008 테이블 INSERT 하기

SQL Server 2008 테이블 INSERT 하기

 

 

-- 우선테이블생성부터.

   

USE tempdb;

   

   

IF OBJECT_ID('dbo.Test', 'U') IS NOT NULL DROP TABLE dbo.Test;

   

CREATE TABLE dbo.Test(

orderid INT NOT NULL,

orderdate DATE NOT NULL,

empid INT NOT NULL,

custid VARCHAR(5) NOT NULL,

qty INT NOT NULL,

CONSTRAINT PK_Orders PRIMARY KEY(orderid)

);

   

   

-- 기존SQL 2000 , 2005 에서는테이블을생성후데이터를입력할때마다INSERT 구문을붙어줘야했다.

   

   

   

INSERT INTO dbo.TEST (orderid, orderdate, empid, custid, qty) VALUES (30001, '20070802', 3, 'A', 10)

   

INSERT INTO dbo.TEST (orderid, orderdate, empid, custid, qty) VALUES (10001, '20071224', 2, 'A', 12)

   

INSERT INTO dbo.TEST (orderid, orderdate, empid, custid, qty) VALUES (10005, '20071224', 1, 'B', 20)

   

   

   

SELECT * FROM dbo.Test;

   

   

   

   

   

   

-- SQL 2008에서는좀더편하게바뀌었다. 기존2000, 2005의방식도사용가능하다.

   

INSERT INTO dbo.Test(orderid, orderdate, empid, custid, qty)

VALUES

(30001, '20070802', 3, 'A', 10),

(10001, '20071224', 2, 'A', 12),

(10005, '20071224', 1, 'B', 20)

   

SELECT * FROM dbo.Test;