SQL SERVER的视图、存储过程等

视图
    创建视图：
        CREATE VIEW view_name
        [WITH ENCRYPTION]
        AS
        select_statement
    修改视图：
        ALTER VIEW view_name
        [WITH ENCRYPTION]
        AS
        select_statement
    删除视图：
        DROP VIEW view_name

存储过程
    创建存储过程：
        CREATE PROCEDURE procedure_name
        [WITH ENCRYPTION]
        [WITH RECOMPLIE]
        AS
        sql_statement
    带参数的存储过程：
        CREATE PROCEDURE procedure_name
        @parameter_name datatype=[default]
        [WITH ENCRYPTION]
        [WITH RECOMPLIE]
        AS
        sql_statement