























视图
创建视图:
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 阅读(311) 评论() 收藏 举报
此内容由惯性聚合(RSS阅读器)自动聚合整理,仅供阅读参考。 原文来自 — 版权归原作者所有。