Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 Transact-SQL (2000)
 Error while creating Primark Key.

Author  Topic 

mohit_sharan
Starting Member

22 Posts

Posted - 2003-11-24 : 00:51:54
Hi,

I want to create primary key based on one colum. The issue is while creaing Primary Key the data are not case secsetive. For Example : 0500951081994A0014B081 001
0500951081994A0014b081 001

Both are treated as same. Is there a way to take the data as case sencetive while creating Primary Key. So that the above values will be taken as two diffrent record.

Thanks with Regards.
-Mohit.

Merkin
Funky Drop Bear Fearing SQL Dude!

4970 Posts

Posted - 2003-11-24 : 05:13:53
You only need to post once. Do you think we won't notice their other ones ??


Damian
Go to Top of Page
   

- Advertisement -