Tag: Color

Microsoft SQL Server

MS SQL: Store a Color (ARGB) as an Integer in Transact-SQL

The most common way is to store colors in a SQL database as a string, i.e. the HTML color code (ex. #FFFFFF). The colors can also be stored as 32 bit integers. A 32 bit color value (including alpha channel) can be calculated in the following way: @Alpha * 16777216 + @Red * 65536 + @Green * 256 + @Blue The complete user-defined […]

Back To Top

Subscribe to our newsletter