p2p.wrox.com Forums

Need to download code?

View our list of code downloads.


  Return to Index  

aspdotnet_website_programming thread: sp_Accounts_DeleteUser


Message #1 by "Ricardo Barros Figueira" <RBFigueira@m...> on Fri, 17 Jan 2003 16:20:33 -0000
Friends,

Anyone can post here this Stored Procedure : sp_Accounts_DeleteUser

Thanks :P

Best regards,
Ricardo Figueira (RBFIGUEIRA)
Moderador Lista PontoNetPT
http://groups.yahoo.com/group/PontoNetPT
DotNetPortuguese List in Portuguese Language

Message #2 by David Barnes <DavidB@w...> on Fri, 17 Jan 2003 16:32:07 -0000
Hi Ricardo

Here you go:
 . . . . . . . . . . . . . . . . . . . . . . . .

CREATE PROCEDURE sp_Accounts_DeleteUser
@UserID int
AS
     DECLARE @MemberID int

     SELECT @MemberID = MemberId FROM Forums_Members WHERE UserId = @UserId

     IF @MemberID IS NOT NULL
     BEGIN
          DELETE Forums_Members WHERE UserId = @UserId
          DELETE Forums_Topics WHERE MemberId = @MemberId
          DELETE Forums_Replies WHERE MemberId =  @MemberId
     END

     DELETE Accounts_UserRoles WHERE UserId = @UserId
     DELETE ACcounts_Users WHERE UserId = @UserId
GO
 . . . . . . . . . . . . . . . . . . . . . . . .

Best add that to the download now... Oops!

Dave

> -----Original Message-----
> From: Ricardo Barros Figueira [mailto:RBFigueira@m...]
> Sent: Friday, January 17, 2003 4:21 PM
> To: Website Programming with ASP.NET
> Subject: [aspdotnet_website_programming] sp_Accounts_DeleteUser
> 
> 
> Friends,
> 
> Anyone can post here this Stored Procedure : sp_Accounts_DeleteUser
> 
> Thanks :P
> 
> Best regards,
> Ricardo Figueira (RBFIGUEIRA)
> Moderador Lista PontoNetPT
> http://groups.yahoo.com/group/PontoNetPT
> DotNetPortuguese List in Portuguese Language
> 
> 
> ---
> Professional Design Patterns in VB.NET: 
> Building Adaptable Applications
> 
> Want to know how design patterns bring reusable 
> design and adaptabilty to your applications? How 
> to recognize the need for a design pattern 
> solution? How to select, design, and implement 
> the right patterns? How parts of the .NET Framework 
> (like the .NET Data Providers and .NET Remoting) 
> take advantage of design patterns? This book 
> presents a practical approach to using design 
> patterns in VB.NET, by focusing on the relevance 
> of design patterns in the different tiers of a 
> distributed n-tier architecture. 
> 
> http://www.wrox.com/books/1861006985.htm
> 
> 

  Return to Index