Check data

Question

How to check the input data is already exist or not in the database? Thank you for your help.

Sibeesh Venu · Answer

Hi You can follow so many ways to achieve this. Some of them are explained below. Please have a look. http://forums.asp.net/t/1345572.aspx?C+Sql+server+checking+whether+a+value+already+exists+in+the+Database http://www.codeproject.com/Questions/565011/StoredplusProcedureplusC-plus-plus-IFplusEXIST https://support.office.com/en-au/article/Create-and-use-an-index-to-improve-performance-0a8e2aa6-735c-4c3a-9dda-38c6c4f1a0ce?CorrelationId=60f214c1-5c47-458a-8b62-5ab2eebc5c90&ui=en-US&rs=en-AU&ad=AU Please up vote and accept if it helps you. Kindest Regards Sibeesh Venu www.sibeeshpassion.com

Asp.Net Hein · Answer

If you want to answer my question  kindly explain with code.Your explaination is not absolutely clear to me.

Syed Shanu · Answer

You can create a Stored procedure and pass the input data as Parameter to Stored Procedure. sample table creation IF EXISTS ( SELECT [name] FROM sys.tables WHERE [name] = 'UserMasters' ) DROP TABLE UserMasters GO CREATE TABLE [dbo].[UserMasters]( [USR_ID] [varchar](20) NOT NULL [User_Name] [varchar](100) NOT NULL [Email] [varchar](100) NOT NULL [Phone] [varchar](20) NOT NULL [Address] [varchar](300) NOT NULL CONSTRAINT [PK_UserMasters] PRIMARY KEY CLUSTERED ( [USR_ID] ASC )WITH (PAD_INDEX = OFF STATISTICS_NORECOMPUTE = OFF IGNORE_DUP_KEY = OFF ALLOW_ROW_LOCKS = ON ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] ) ON [PRIMARY] INSERT INTO [DynamicProject].[dbo].[UserMasters] ([USR_ID][User_Name][Email][Phone][Address]) VALUES ('USR001''SAHNU''syedshanumcain@gmail.com''01030550000''From India Lives In Korea') // here is a sample stored procedure where i will check for Userid and userName is already exisit or not.If its not exisit then i will insert the data. -- Author : Shanu -- Create date : 2015-02-05 -- Description : To Insert User Master -- Tables used : ItemMasters -- Modifier : Shanu -- Modify date : 2015-02-05 -- ============================================= -- exec USP_User_Insert 'Usr002''Afraz' 'afraz@gmail.com''0100000''my address' -- ============================================= Create PROCEDURE [dbo].[USP_User_Insert] ( @USR_ID VARCHAR(20) = '' @User_Name VARCHAR(100) = '' @Email VARCHAR(100) = '' @Phone VARCHAR(100) = '' @Address VARCHAR(100) = '' ) AS BEGIN IF NOT EXISTS (SELECT * FROM UserMasters WHERE USR_ID=@USR_ID and User_Name=@User_Name ) BEGIN INSERT INTO [UserMasters] ([USR_ID][User_Name][Email][Phone][Address]) VALUES (@USR_ID@User_Name@Email@Phone@Address) select 'Inserted' as 'Result' END ELSE BEGIN select 'Error Insert' as 'Result' END END -- To execute and test the SP run the below code. exec USP_User_Insert 'Usr002''Afraz' 'afraz@gmail.com''0100000''my address'

Akhil Garg · Answer

Take the data and pass it to database and compare it exists in database or not like we used to match password and email for login.