Loading

Unique Data

Unique Data

Ramco Ramco

3y880SQL

Hi

IN below data i want Student Id & Date to be unique

 Student Detail

 ID Primary (Identity), Student ID, Join Date , Marks

Thanks

1 Reply

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

Amit Mohanty3y ago
If you want uniqueness on the combination of Student ID and Date columns in the Student Detail table, you can create a unique constraint or a unique index on those columns.
```
   ALTER TABLE [StudentDetail]
ADD CONSTRAINT [UQ_StudentDetail_StudentID_Date] -- Replace with the desired name 
       UNIQUE ([StudentID], [JoinDate]); 
```