I want to check that in my database value is exist or not for example email is i want register in my website it this email is already registerd then it shows ,
i am using sql server 2005 and vb.net 2005
use following Store Proceduer if it returns true then exist other wise not exists
Create PROCEDURE Sp_IsEmailExist@Email VARCHAR(50)ASBEGIN SET NOCOUNT ON; IF EXISTS (SELECT Email FROM TABLENAME WHERE Email = @Email ) BEGIN SELECT 1 END ELSE BEGIN SELECT 0 END END
© COPYRIGHT 2024 ASPSnippets.com ALL RIGHTS RESERVED.