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 2005 Forums
 Transact-SQL (2005)
 Assiging fixed values to column

Author  Topic 

Shankarooni
Starting Member

2 Posts

Posted - 2009-03-25 : 10:16:34
I want to define a colum X with list of character values : Y, Z or H...

How can I do that

alsdasdaklsdasd
^ Exactly!

heavymind
Posting Yak Master

115 Posts

Posted - 2009-03-25 : 10:53:00
you need to add check constraint to your column if I got you right.

Thanks, Vadym
MCITP DBA 2005/2008
Chief DBA at http://www.db-staff.com
Go to Top of Page

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2009-03-25 : 13:40:22
or are you asking about storing comma delimited string of characters? then declare the field as varchar type.
Go to Top of Page

Shankarooni
Starting Member

2 Posts

Posted - 2009-03-25 : 14:32:29
http://stackoverflow.com/questions/681828/sqlserver-how-to-bind-fixed-values-to-column

I asked in the site above & get great feedback!

Thank you all

alsdasdaklsdasd
^ Exactly!
Go to Top of Page
   

- Advertisement -