Best Regard's Prabhakar
GO /****** Object: StoredProcedure [dbo].[sp_CheckemailExistance] Script Date: 01/04/2012 10:51:12 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO ALTER PROCEDURE [dbo].[sp_CheckemailExistance] ( @EMAIL varchar(40), @RESULTS INT OUTPUT ) AS SET @RESULTS = (SELECT COUNT(*) FROM USERS WHERE EMAIL = @EMAIL)
Thank you for posting at Dotnetfunda [Administrator]
Login to post response