在存储过程中需要帮助 [英] need help in Store Procedure

问题描述

根据您的建议，我正在下面的页面上查找sql​​存储过程....但是我真的无法理解.... plz可以帮助我.....



http://msdn.microsoft.com/en-us/library/aa174792(SQL .80).aspx [ ^ ]

as per your suggestion I was looking on this below page for sql store procedure....But I am really unable to understand anything....plz help me.... .



http://msdn.microsoft.com/en-us/library/aa174792(SQL.80).aspx[^]

推荐答案

嗨...

它是简单的SP.

Hi ...

It is the simple SP.

create procedure procedurename
(
@id varchar(6) //parameters
)
as
begin


select * from custinfo where cust id=@id //Your's query


end

To execute the procedure

exec procedurename '2'//parameter value

如果您只是想开始使用存储过程，那么Arul就是一个很好的起点.您可以操纵并尝试轻松地从他的示例中学习.如果您已经知道这一点，则将遇到特定的问题.然后只有一个人可以提供帮助.

If you just wanted to start with Stored Procedure, Arul has given a good starting point. You can manipulate and try to learn from his example easily. If you know already about this come with specific problem. Then only one can help.

尝试一下 [

这篇关于在存储过程中需要帮助的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！