初学存储过程,只会加些简单的sql,看看这个存储过程还可以怎么优化一下,让性能更好
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[home]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[home]
GOCREATE PROCEDURE [dbo].[home]
AS
set nocount on
begin
select top 7 ID,nickname,Birthday,height,Province,City from [dbo].[user] where sex = '男' order by ID desc
select top 7 ID,nickname,Birthday,height,Province,City from [dbo].[user] where sex = '女' order by ID desc
select top 3 content,Pub_Datetime from [dbo].[news] order by ID desc
select ID,nickname,UserPhoto from [dbo].[user] where IsValid = 1 and IsStar = 1
select top 8 ID,nickname,Birthday,height,Province,City from [dbo].[user] where Rank >= 1 and sex = '男' order by Start_Datetime desc
select top 8 ID,nickname,Birthday,height,Province,City from [dbo].[user] where Rank >= 1 and sex = '女' order by Start_Datetime desc
select top 8 ID,title,Party_date from [dbo].[party] where IsValid = 1 order by Party_date desc
select top 8 ID,topic,Pub_Datetime from [dbo].[bbs] order by ID desc
end
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[home]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[home]
GOCREATE PROCEDURE [dbo].[home]
AS
set nocount on
begin
select top 7 ID,nickname,Birthday,height,Province,City from [dbo].[user] where sex = '男' order by ID desc
select top 7 ID,nickname,Birthday,height,Province,City from [dbo].[user] where sex = '女' order by ID desc
select top 3 content,Pub_Datetime from [dbo].[news] order by ID desc
select ID,nickname,UserPhoto from [dbo].[user] where IsValid = 1 and IsStar = 1
select top 8 ID,nickname,Birthday,height,Province,City from [dbo].[user] where Rank >= 1 and sex = '男' order by Start_Datetime desc
select top 8 ID,nickname,Birthday,height,Province,City from [dbo].[user] where Rank >= 1 and sex = '女' order by Start_Datetime desc
select top 8 ID,title,Party_date from [dbo].[party] where IsValid = 1 order by Party_date desc
select top 8 ID,topic,Pub_Datetime from [dbo].[bbs] order by ID desc
end
GO
以上是我的看法.