ALTER PROCEDURE Sales_UserLoad
@username char(10)=null,@password varchar(50)=null
AS
if (@username is null and @password is null) or (@username='' and @password='')
SELECT [username] FROM sales_users
else
SELECT * FROM sales_users
WHERE [username] = @username AND [password] = @password
RETURN
@username char(10)=null,@password varchar(50)=null
AS
if (@username is null and @password is null) or (@username='' and @password='')
SELECT [username] FROM sales_users
else
SELECT * FROM sales_users
WHERE [username] = @username AND [password] = @password
RETURN
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货