Re: bitwise operation questions
From: Craig Buchanan (someone_at_somewhere.com)
Date: 02/27/04
- Next message: msnews.microsoft.com: "Sql Query Question."
- Previous message: Piers Lawson: "RE: Blocked remote calls with COM+ and MSDTC"
- In reply to: Joe Celko: "Re: bitwise operation questions"
- Next in thread: Joe Celko: "Re: bitwise operation questions"
- Reply: Joe Celko: "Re: bitwise operation questions"
- Messages sorted by: [ date ] [ thread ]
Date: Fri, 27 Feb 2004 07:41:16 -0600
never, smart guy. i figured that adding bits would be a simple solution,
rather than having to maintain yet another table. Values for the field are
provided by application enumeration.
Perhaps you could just answer my question.
"Joe Celko" <joe.celko@northface.edu> wrote in message
news:uBUOXoM$DHA.2348@TK2MSFTNGP09.phx.gbl...
> >> I would like to store mailing-list preferences in an Int field [sic]
> using bitwise operators, but I'm having a bit of difficultly. The field
> [sic] is named 'EmailFlags'.
> <<
>
> How long were you an assembly language programmer?
>
> Rows are not records; fields are not columns; tables are not files. We
> do not do things this way in SQL and in the 21-st century. The whole
> idea is to work at a much higher level of abstraction, not at the
> hardware level. SQL does not refer to bits and bytes.
>
> Look up "Relational Division"; it was one of Codd's original eight
> relational operations.
>
> --CELKO--
> ===========================
> Please post DDL, so that people do not have to guess what the keys,
> constraints, Declarative Referential Integrity, datatypes, etc. in your
> schema are.
>
> *** Sent via Developersdex http://www.developersdex.com ***
> Don't just participate in USENET...get rewarded for it!
- Next message: msnews.microsoft.com: "Sql Query Question."
- Previous message: Piers Lawson: "RE: Blocked remote calls with COM+ and MSDTC"
- In reply to: Joe Celko: "Re: bitwise operation questions"
- Next in thread: Joe Celko: "Re: bitwise operation questions"
- Reply: Joe Celko: "Re: bitwise operation questions"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
