flags enum in Sql

I've been looking for the answer to this most of the day...Books Online doesn't say anything about how to solve this...

Anyone know how to make the equivilant of a "flags enum" in Sql 2000?

Comments

• Anonymous
  February 17, 2005
  in what way do you mean, it can perform bitmask ops...?
• Anonymous
  February 17, 2005
  If you just mean storing the flags, then wouldn't any of the integral numeric types work? In the end, it's just an integer, right?
• Anonymous
  February 17, 2005
  Well, let's see if I can explain a little better...
  
  Have a table called MyFlags with an ID column, and a Name column. The ID's would incriment as follows...1, 2, 4, 8, 16, 32, etc...
  
  Then I'd have another table called TestTheFlag with a column called SetFlags which would have a foreign key constraint set against the ID column of the MyFlags table.
  
  I'm more or less wondering if there's any built in way to do this...I can probably figure out a way to do no matter what, but if there's something built in to do it...I'd much rather use that. :)
• Anonymous
  February 17, 2005
  http://forums.devshed.com/archive/t-100599/enumequivalent-data-type-for-MS-SQL-2000
  I'm not sure whether this is what u look for..
• Anonymous
  February 17, 2005
  yeah, that's a good start Srikanth. Thank you. :)
• Anonymous
  May 17, 2005
  The www.53dy.com is free movies web site , all movies is free !
  Welcome to our web site !
  http://www.53dy.com">http://www.53dy.com
  免费电影 www.53dy.com 全部电影完全免费!
  欢迎光临免费电影
  http://www.53dy.com">http://www.53dy.com
  The www.k58.org is free movies web site , all movies is free !
  Welcome to our web site !
  http://www.k58.org">http://www.k58.org
  免费电影 www.k58.org 全部电影完全免费!
  欢迎光临免费电影
  http://www.k58.org">http://www.k58.org
• Anonymous
  July 23, 2005
  http://www.2121t.com/0507001.html
  http://www.2121t.com/0507002.html
  http://www.2121t.com/0507003.html
  http://www.2121t.com/0507004.html
  http://www.2121t.com/0507005.html
  http://www.2121t.com/0507006.html
  http://www.2121t.com/0507007.html
  http://www.2121t.com/0507008.html
  http://www.2121t.com/0507009.html
  http://www.2121t.com/0507010.html
  http://www.2121t.com/0507011.html
  http://www.2121t.com/0507012.html
  http://www.2121t.com/0507013.html
  http://www.2121t.com/0507014.html
  http://www.2121t.com/0507015.html
  http://www.2121t.com/0507016.html
  http://www.2121t.com/0507017.html
  http://www.2121t.com/0507018.html
  http://www.2121t.com/0507019.html
  http://www.2121t.com/0507020.html
  http://www.2121t.com/0507021.html
  http://www.2121t.com/0507022.html
  http://www.2121t.com/0507023.html
  http://www.2121t.com/0507024.html
  http://www.2121t.com/0507025.html
  http://www.2121t.com/0507026.html
  http://www.2121t.com/0507027.html
  http://www.2121t.com/0507028.html
  http://www.2121t.com/0507029.html
  http://www.2121t.com/0507030.html
  http://www.2121t.com/0507031.html
  http://www.2121t.com/0507032.html
  http://www.2121t.com/0507033.html
  http://www.2121t.com/0507034.html
  http://www.2121t.com/0507035.html
  http://www.2121t.com/0507036.html
  http://www.2121t.com/0507037.html
  http://www.2121t.com/0507038.html
  http://www.2121t.com/0507039.html
  http://www.2121t.com/0507040.html
  http://www.2121t.com/0507041.html
  http://www.2121t.com/0507042.html
  http://www.2121t.com/0507043.html
  http://www.2121t.com/0507044.html
  http://www.2121t.com/0507045.html
  http://www.2121t.com/0507046.html
  http://www.2121t.com/0507047.html
  http://www.2121t.com/0507048.html
  http://www.2121t.com/0507049.html
  http://www.2121t.com/0507050.html
  
• Anonymous
  July 23, 2005
  http://520meimei.zj.com/zp.htm
  http://520meimei.zj.com/crxs.htm
  http://520meimei.zj.com/hsxs.htm
  http://520meimei.zj.com/index01.htm
  http://520meimei.zj.com/index02.htm
  http://520meimei.zj.com/index03.htm
  http://520meimei.zj.com/index05.htm
  http://520meimei.zj.com/index06.htm
  http://520meimei.zj.com/index07.htm
  http://520meimei.zj.com/index08.htm
  http://520meimei.zj.com/index09.htm
  http://520meimei.zj.com/index10.htm
  http://520meimei.zj.com/index11.htm
  http://520meimei.zj.com/index12.htm
  http://520meimei.zj.com/index13.htm
  http://520meimei.zj.com/index15.htm
  http://520meimei.zj.com/jqdy.htm
  http://520meimei.zj.com/kddy.htm
  http://520meimei.zj.com/kdy.htm
  http://520meimei.zj.com/kdyy.htm
  http://520meimei.zj.com/mfdy.htm
  http://520meimei.zj.com/mfyy.htm
  http://520meimei.zj.com/mxxz.htm
  http://520meimei.zj.com/nx.htm
  http://520meimei.zj.com/rtxz.htm
  http://520meimei.zj.com/rtys.htm
  http://520meimei.zj.com/sjdy.htm
  http://520meimei.zj.com/sjp.htm
  http://520meimei.zj.com/sqxs.htm
  http://520meimei.zj.com/swdy.htm
  http://520meimei.zj.com/xdy.htm
  http://520meimei.zj.com/xsh.htm
  http://520meimei.zj.com/xzdy.htm
  http://520meimei.zj.com/xzmfdy.htm
  http://520meimei.zj.com/yqdy.htm
  http://520meimei.zj.com/tt.htm
  http://520meimei.zj.com/xz.htm
  http://520meimei.zj.com/lt.htm
  http://520meimei.zj.com/mv.htm
  http://520meimei.zj.com/splt.htm
  http://520meimei.zj.com/qqsplt.htm
  http://520meimei.zj.com/tj.htm
  http://520meimei.zj.com/hj.htm
  http://520meimei.zj.com/jy.htm
  http://520meimei.zj.com/mmo.htm
  http://520meimei.zj.com/mx.htm
  http://520meimei.zj.com/sk.htm
  http://520meimei.zj.com/hp.htm
  
  
  
• Anonymous
  July 23, 2005
  http://www.17ccc.com/gle/dywz.htm
  http://www.17ccc.com/gle/sqtp.htm
  http://www.17ccc.com/gle/crlt.htm
  http://www.17ccc.com/gle/mvzp.htm
  http://www.17ccc.com/gle/xztp.htm
  http://www.17ccc.com/gle/ltmv.htm
  http://www.17ccc.com/gle/18dy.htm
  http://www.17ccc.com/gle/rtxz.htm
  http://www.17ccc.com/gle/xdy.htm
  http://www.17ccc.com/gle/xzdy.htm
  http://www.17ccc.com/gle/dylt.htm
  http://www.17ccc.com/gle/mr.htm
  http://www.17ccc.com/gle/tiet.htm
  http://www.17ccc.com/gle/rtys.htm
  http://www.17ccc.com/gle/mx.htm
  http://www.17ccc.com/gle/hj.htm
  http://www.17ccc.com/gle/splt.htm
  http://www.17ccc.com/gle/xz.htm
  http://www.17ccc.com/gle/wyzp.htm
  http://www.17ccc.com/gle/jy.htm
  http://www.17ccc.com/gle/lt.htm
  http://www.17ccc.com/gle/dm.htm
  http://www.17ccc.com/gle/minx.htm
  http://www.17ccc.com/gle/sk.htm
  http://www.17ccc.com/gle/xx.htm
  http://www.17ccc.com/gle/mm.htm
  http://www.17ccc.com/gle/mfdy.htm
  http://www.17ccc.com/mfdy/
  http://www.17ccc.com/gle/meinv.htm
  http://goog06.zj.com/mfdy518.html
  http://goog06.zj.com/ddd.html
  http://goog06.zj.com/jj.html
  http://goog06.zj.com/lx.html
  http://goog06.zj.com/tj.html
  http://goog06.zj.com/ttu.html
  http://goog06.zj.com/mm.html
  http://goog06.zj.com/520.html
  http://goog06.zj.com/wyzp.html
• Anonymous
  July 23, 2005
  http://goog01.zj.com
  http://goog02.zj.com
  http://goog03.zj.com
  http://goog05.zj.com
  http://goog06.zj.com
  http://372101.zj.com
  http://372102.zj.com
  http://372103.zj.com
  http://372105.zj.com
  http://wangyouzp.mblogger.cn
  http://5151ccc.zj.com
  http://mianfeidianyy.blogdriver.com
  http://shipingliaotian.blogdriver.com
  http://shipliaot.blogdriver.com
  http://huangsedy.blogdriver.com
  http://meinvxiez.mblogger.cn
  http://xiaodiany.ebloggy.com
  http://chengrltt.ebloggy.com
  http://chengrendiany.ebloggy.com
  http://chengrenxiaosuo.ebloggy.com
  http://mianfeidiany2006.blogchina.com
  http://xiaody.blogchina.com
  http://chengrendiany.yculblog.com
  http://xiaodiany.yculblog.com
  http://shipingliaotian.yculblog.com
  http://chengrdiany.mblogger.cn
  http://rtyishu.mblogger.cn
  http://chengrxiaos.mblogger.cn
  http://mianfeidianying11.mblogger.cn
• Anonymous
  January 30, 2006
  The comment has been removed
• Anonymous
  January 30, 2006
  The comment has been removed
• Anonymous
  January 30, 2006
  The comment has been removed
• Anonymous
  January 30, 2006
  The comment has been removed
• Anonymous
  January 30, 2006
  The comment has been removed
• Anonymous
  May 29, 2009
  PingBack from http://paidsurveyshub.info/story.php?title=toffer-s-weblog-flags-enum-in-sql