如何将此sql查询转换为存储过程？ [英] How can I convert this sql query to a stored procedure?

问题描述

展开 | 选择 | Wrap | 行号

推荐答案

从以下处开始：

Start it with:

展开 | 选择 | Wrap | 行号

hi akocjello，

创建如下的程序。

创建程序procedurename

as

begin

//写下你想要执行的查询

//例如select * from tablename

结束


然后


执行程序procedurename

hi akocjello,
create the procedure like below.
create procedure procedurename
as
begin
//write the query u want to perform
// e.g select * from tablename
end


then

execute procedure procedurename

当您选择创建或添加新的存储过程时，将为您插入所有这些标题和尾随位。您只需要填写名称等和SQL并保存即可。很难想象为什么你需要问这样一个问题，除非你先没有亲自看过它。

When you choose to create or add a new Stored Procedure all these heading and trailing bits are inserted for you. You simply need to fill in the name etc. and the SQL and save it. It''s hard to imagine why you would need to ask such a question unless you hadn''t even looked at it for yourself first.

这篇关于如何将此sql查询转换为存储过程？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！