当我尝试创建下面的存储过程时,出现了以下错误:
操作数类型冲突:uniqueidentifier与int不兼容
我不清楚是什么导致了这个错误。实际上,在我的所有表格中,UserID确实是一个int类型。有人能告诉我我做错了什么吗?
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
aspnet_Membership
肯定使用guids
吧? - Martin Smith