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
创建视图:
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
posted on 2006-01-20 12:08 samuel's blog 阅读(302) 评论(0) 编辑 收藏 举报