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