求教一个简单的存储过程写法

[chenguohui]

简单的存储过程
我没有写过存储过程，我想实现下面的功能

Create procedure test1 @str_date char(10)

as int js;
begin
select sum(js) as js1 from k_send where date:=str_date
js=js1

insert into k_sum (js,date) values (js1,str_date)
end
正确的写法应该是怎么样的呢？
有谁知道哪里有专门介绍存储过程的数下载呢?谢谢了。

[leisa]

CREATE PROCEDURE [OWNER].[PROCEDURE NAME] @str_date char(10) AS
insert into k_sum (js,date) select sum(js),@str_date from k_send where DateDiff(d,date,datestr_date)=0

楼上的各位写法没有错，只是我觉得程序能够精炼就精炼一点好，大家觉得呢？

[CCEO]

Create procedure test1 @str_date datetime

as
begin
insert into k_sum (js,[date])
select sum(js) as js1,@str_date as [date] from k_send where date=@str_date
end

[CABO]

Create procedure test1 @str_date char(10)
as
declare @js int
begin
select @js=sum(js) from k_send where date=@str_date
insert into k_sum (js,date) values (@js,@str_date)
end

[19191919]

Create procedure test1 (@str_date char(10))
as

declare @js int
select @js=sum(js) as js1 from k_send where date=@str_date
insert into k_sum (js,date) values (@js,@str_date)

ok了，1 存储过程里不用begin ..end
2 赋值语句可以用select或set
3 声明局部变量要用declare 并且变量名加@

[zhang2544669]

CREATE PROCEDURE [OWNER].[PROCEDURE NAME] @str_date char(10) AS
declare @js1 int

begin
select js1=sum(js) from k_send where date=str_date
insert into k_sum (js,date) values (js1,str_date)
end
随便找一本书就有介绍存储过程的。