Stored procedure - review
Mål:BO_Email1 ind
Username ud
Det virker, men vil gerne have review på at gøre det lækkert.
/****** Object: Stored Procedure sp_do_userinfo_by_email ******/
/*
* PROCEDURE sp_do_userinfo_by_email
*/
CREATE PROCEDURE sp_do_userinfo_by_email
(@BO_Email1 varchar(65))
AS
BEGIN
SELECT Username FROM TUser WHERE BO_Email1 = @BO_Email1 order by ID desc
RETURN(0)
END
GO