存储过程

通过这次做仿新浪微博的项目，，让我认识到了存储过程的方便实用性，而且使用存储过程能够大幅度的提高数据的操作速度，下面我就来分享一下我通过这次项目所使用的存储过程：
数据库设计：
<img src="http://my.csdn.net/uploads/201204/03/1333415249_8021.png" alt=""><img src="http://my.csdn.net/uploads/201204/03/1333415298_3659.png" alt="">
分页存储过程：（）
ALTER proc [dbo].[procfenye] 
@pageindex int,
@userid int
as
select *from (select ROW_NUMBER() over (order by userid) as rownumb,* from T_User where userid not in 
(select Friend_id  from T_FriendList where User_id=@userid and UserState=1)
and userid not in (select Friend_id from T_FriendList where Friend_id=@userid and FriendState=1)and userid!=@userid) t
where t.rownumb>(@pageindex-1)*5 and t.rownumb<=@pageindex*5
全部关注：
ALTER proc [dbo].[ProcAllattention]
@userid int
as
select * from T_User where userid in (select Friend_id from T_FriendList where (User_id=@userid and UserState=1))
or userid in (select userid from T_FriendList where (Friend_id=@userid and UserState=1))
取消关注：
<pre name="code" class="sql">ALTER proc [dbo].[ProcCancel]
@userid int,
@friendid int
as

update T_FriendList set UserState=0 where (User_id=@userid and Friend_id=@friendid and UserState=1)
UPDATE T_FriendList set FriendState=0 where (User_id=@friendid and Friend_id=@userid and FriendState=1)</pre>