SQL Query to Restrict Entry of Same Data in a Table

Sir, I need your help in the following:-

I want SQL Query to restrict same data entry. Please take a look to the following Row:-

id                Name                Address       Age                        Place            Department          Salary

1                 Sam                3rd street, madgaon, Chennai                        24                      Chennai              Sales                20000

2                 Sam                3rd street, madgaon, Chennai                        24                      Chennai              Sales                20000

This type of Entry does not allowed.

I need a different query than the Query I written below:-

if not exists(select Name, Address, Age, Place, Department, Salary from tbl_Employee where Name=@Name and Address=@Address and Age=@Age and Place=@Place and Department=@Department and Salary=@Salary)

begin
insert into tbl_Employee(Name, Address, Age, Place, Department, Salary)
values(@Name, @Address, @Age, @Place, @Department, @Salary)
end

1 Reply

Know the answer? Post it — somebody with the same question will find it here.

Mukesh Kumar Tiwari13y ago
Accepted answer
Conn = new SqlConnection(ConnString);
            if (Conn.State == ConnectionState.Closed)
            {
                Conn.Open();
            }
            string query = "select * from student_master where name='" + txtname.Text + "'";
            Cmd = new SqlCommand(query, Conn);
            SqlDataReader dr = Cmd.ExecuteReader();

            if (dr.Read() == true)
            {
               messegebox("Record allready exist");
                return 1;
            }
            else
            {
                insert data();
            }