SELECT @CustomerID = CustomerID
FROM CMRC_Customers
WHERE EmailAddress = @Email AND Password = @Password
IF @@Rowcount < 1
SELECT @CustomerID = 0
@@Rowcount < 1 是指你执行上一条语句,影响了多少行,这里的作用是如果查不出数据就给变量 @CustomerID 赋值0
SELECT @CustomerID = CustomerID
FROM CMRC_Customers
WHERE EmailAddress = @Email AND Password = @Password
IF @@Rowcount < 1
SELECT @CustomerID = 0
@@Rowcount < 1 是指你执行上一条语句,影响了多少行,这里的作用是如果查不出数据就给变量 @CustomerID 赋值0