1if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[p_getInviteList]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
 2drop procedure [dbo].[p_getInviteList]
 3GO
 4
 5create procedure [dbo].[p_getInviteList]
 6@user varchar(20)
 7as
 8
 9DECLARE @bloger bigint,@usefullife datetime
10
11SET @usefullife=DATEADD(month,-1,GETDATE())
12SELECT @bloger=id FROM [user] WHERE account=@user
13
14SELECT
15    friend.id,[user].account,nickname AS "name",remark,invitetime
16FROM
17    friend
18INNER JOIN
19    [user]
20ON
21    [user].id=source
22WHERE
23    target=@bloger AND
24    state=1 AND
25    invitetime>@usefullife
26ORDER BY friend.id
27
28GO