我很难编写一个select语句来比较type中的两个值,这两个值都是图像类型的。到目前为止,这就是我所拥有的:FROM [dbo].[aspnet_Profile] as a inner join [dbo].[aspnet_Profile] as b onWHERE BINARY_CHECKSUM对于上面的查询,我得到的错误消息是
假设我有一个变量'userid',我想从aspnet_Membership和aspnet_AccountProfile表中进行选择。它们都有userid列,我只想能写一条像SELECT * FROM aspnet_AccountProfile,aspnet_Membership WHERE UserId=@UserId这样的语句,它会得到两个表中具有匹配用户