INSERT, DELETE SQL 쿼리문

INSERT

 

 테이블에 새로운 행을 추가할 때는 INSERT문을 사용합니다.

포멧:

[ WITH <common_table_expression> [ ,...n ] ]

INSERT

{

        [ TOP ( expression ) [ PERCENT ] ] [ INTO ]

        { <object> | rowset_function_limited [ WITH ( <Table_Hint_Limited> [ ...n ] ) ] }

    {

        [ ( column_list ) ] [ <OUTPUT Clause> ]

        {

            VALUES ( { DEFAULT | NULL | expression } [ ,...n ] ) [ ,...n     ]

            | derived_table  | execute_statement  | <dml_table_source> | DEFAULT VALUES

        }

    }

}[;]

예:

INSERT INTO Custom

               (CNAME, PHONE, ADDR)

VALUES  ('강감찬', '010-0000-0000', '서울시 종로구 종로1동 1번지')

 

DELETE

 

 테이블의 행을 삭제할 때는 DELETE문을 사용합니다.

포멧:

[ WITH <common_table_expression> [ ,...n ] ]

DELETE

    [ TOP ( expression ) [ PERCENT ] ] [ FROM ]

    {

      { table_alias | <object> | rowset_function_limited [ WITH ( table_hint_limited [ ...n ] ) ] }

      | @table_variable

    }

    [ <OUTPUT Clause> ] [ FROM table_source [ ,...n ] ]

    [ WHERE

        {

            <search_condition> | { [ CURRENT OF { { [ GLOBAL ] cursor_name }  | cursor_variable_name } ] }

        }

    ]

    [ OPTION ( <Query Hint> [ ,...n ] ) ]

[; ]

예:

DELETE FROM Custom WHERE  (CNAME = '강감찬')