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