Varchar with trailing spaces as a Primary Key in SQL Server 2008

Posted by cacaupt on Stack Overflow See other posts from Stack Overflow or by cacaupt
Published on 2009-12-30T11:43:40Z Indexed on 2010/06/10 10:33 UTC
Read the original article Hit count: 364

Is it possible to have a varchar column as a primary key with values like 'a ' and 'a', is gives always this error "Violation of PRIMARY KEY constraint" in MS SQL Server 2008. In Oracle dons't give any error. BTW I'm not implementing this way I'm only trying to migrate the data from oracle to sql server.

Regards

© Stack Overflow or respective owner

Related posts about sql-server

Related posts about sql-server-2008