Stored Procedure things

Create proc sp_submit_topic
2
3 @ topicid int,
4 @ content varchar (1000 ),
5 @ uid varchar (20 ),
6 @ datetime
7
8
9
10 begin tran -- Development
11
12 insert into tb_re_topic
13 values
14 (
15 @ topicid, @ uid, @ content, @ datetime
16)
17
18 if @ error <> 0 -- indicates an error has occurred.
19 begin
20 rollback tran -- rollback
21 End
22
23 -- if no error occurs, continue to execute
24
25 declare @ value int
26
27 select @ value = to_num from tb_topic where _ id = @ topicid
28
29 update tb_topic set to_num = @ value + 1 where _ id = @ topicid
30
31 if @ error <> 0 -- judge again whether an error has occurred
32 begin
33 rollback tran
34 end
35
36 commit tran -- submit a transaction