How to restrict duplicate record insertion in SQL Server database

yogesjos...

i have a text box and label ..

database table contain sno, name

sno is primary key so it does not take duplicate value.

how we can name can't take duplicate value...if it already exist then show msg already exist.

need solution urgently..

Mudassar

0 1

In your Stored procedure check

IF NOT EXISTS(SELECT Sno FROM Table WHERE Name=@Name)
BEGIN
--WRITE INSERT QUERY HERE
END

I agree, here is the link: https://www.e-iceblue.com/Introduce/spire-office-for-net-free.html