No, it will not be fully-portable. Packing options for structs are extensions, and are themselves not fully portable. In addition to that, C99 ยง6.7.2.1, paragraph 10 says: “The order of allocation of bit-fields within a unit (high-order to low-order or low-order to high-order) is implementation-defined.” Even a single compiler might lay the bit field out … Read more
A TINYINT is an 8-bit integer value, a BIT field can store between 1 bit, BIT(1), and 64 bits, BIT(64). For a boolean values, BIT(1) is pretty common.
cast ( case when FC.CourseId is not null then 1 else 0 end as bit) The CAST spec is “CAST (expression AS type)”. The CASE is an expression in this context. If you have multiple such expressions, I’d declare bit vars @true and @false and use them. Or use UDFs if you really wanted… DECLARE … Read more
In C, the language itself does not determine the representation of certain datatypes. It can vary from machine to machine, on embedded systems the int can be 16 bit wide, though usually it is 32 bit. The only requirement is that short int <= int <= long int by size. Also, there is a recommendation … Read more