When I attempt to create the stored procedure below I get the following error:
Operand type clash: uniqueidentifier is incompatible with int
It's not clear to me what is causing this error. UserID is in fact an int in all of my tables. Can someone tell me what I've done wrong?
create procedure dbo.DeleteUser(@UserID int) as delete from [aspnet_Membership] where UserId = @UserID delete from [Subscription] where UserID = @UserID delete from [Address] where UserID = @UserID delete from [User] where UserID = @UserID go