블로그 테스트입니다.

공부중입니다.
아래의 사이트에서 일부 발췌하였습니다.
<a href="http://winapi.co.kr/toollec/SQL/SQL.htm">http://winapi.co.kr/toollec/SQL/SQL.htm</a>


CREATE DATABASE database_name
    [ ON
        [ PRIMARY ] [ <filespec> [ ,...n ]
        [ , <filegroup> [ ,...n ] ]
    [ LOG ON { <filespec> [ ,...n ] } ]
    ]
    [ COLLATE collation_name ]
    [ WITH <external_access_option> ]
]
[;]



<filespec> ::=
{
(
    NAME = logical_file_name ,
    FILENAME = 'os_file_name'
        [ , SIZE = size [ KB | MB | GB | TB ] ]
        [ , MAXSIZE = { max_size [ KB | MB | GB | TB ] | UNLIMITED } ]
        [ , FILEGROWTH = growth_increment [ KB | MB | GB | TB | % ] ]
) [ ,...n ]
}




CREATE TABLE tblCountry
(
      Name NVARCHAR(30) NOT NULL PRIMARY KEY,
      Capital NVARCHAR(30) NULL ,
      Popu INT NULL ,
      Cont NCHAR(2) NULL CHECK (Cont IN ('AS', 'SA', 'NA', 'EU', 'AF', 'AU')),
      Area INT NULL
);


CREATE TABLE tblSales
(
      OrderNo INT IDENTITY(1,1) PRIMARY KEY NOT NULL,
      Date DATETIME NULL,
      Customer NCHAR(10) NULL,
      Item NCHAR(30) NULL
);



INSERT INTO tblSales (Date, Customer, Item) VALUES ('2008/5/1','전두환','모자');
INSERT INTO tblSales (Date, Customer, Item) VALUES ('2008/5/1','김영삼','라면');
INSERT INTO tblSales (Date, Customer, Item) VALUES ('2008/5/2','김대중','지팡이');
INSERT INTO tblSales (Date, Customer, Item) VALUES ('2008/5/3','노무현','라면');
INSERT INTO tblSales (Date, Customer, Item) VALUES ('2008/5/8','김영삼','노트북');
INSERT INTO tblSales (Date, Customer, Item) VALUES ('2008/5/8','박정희','볼펜');</filespec></external_access_option></filespec></filegroup></filespec>

CREATE TABLE tblFresher

(

      Name NCHAR(10) PRIMARY KEY NOT NULL,

      Weight INT NULL,

      Height INT NULL,

      Age INT NOT NULL DEFAULT (16),

      Psycho NCHAR(20) NOT NULL DEFAULT (N'이상없음')

);

INSERT INTO tblFresher (Name, Weight, Height) VALUES ('김상형',69,180)

----------------------------------------------------------------

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

CREATE TABLE [dbo].[tblCountry](

      [Name] [nvarchar](30) COLLATE Korean_Wansung_CI_AS NOT NULL,

      [Sudo] [nvarchar](30) COLLATE Korean_Wansung_CI_AS NULL,

      [Popu] [int] NULL,

      [Cont] [int] NULL,

      [Area] [int] NULL,

PRIMARY KEY CLUSTERED

(

      [Name] ASC

)WITH (IGNORE_DUP_KEY = OFF) ON [PRIMARY]

) ON [PRIMARY]

우리가 직접 작성한 스크립트