All pastes #615533 Raw Edit

tobz

public text v1 · immutable
·published 2007-07-12 05:23 UTC
rendered paste body
ALTER PROCEDURE dbo.DoesAccountExistByUsername(@Username varchar(255), @Exists bit OUTPUT)
AS
	IF EXISTS(SELECT 'True' FROM Account WHERE UPPER(Username) = UPPER(@Username))
	BEGIN
		SET @Exists = 1
		RETURN
	END
	
	SET @Exists = 0
	RETURN