存储过程

最新推荐文章于 2017-07-19 11:15:27 发布

iteye_3606

最新推荐文章于 2017-07-19 11:15:27 发布

阅读量237

点赞数

文章标签：数据库

通过这次做仿新浪微博的项目，，让我认识到了存储过程的方便实用性，而且使用存储过程能够大幅度的提高数据的操作速度，下面我就来分享一下我通过这次项目所使用的存储过程：数据库设计：

分页存储过程：（） 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)) 取消关注：

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)