Browse by Tags

Mssql: Cannot use bitwise operators on varbinary or numeric

Published 25 February 8 9:23 AM | Ramon Smits

I want to perform bitwise operations on a varbinary colum. As it contains binary data I though that it would work but it didn't This example works: declare @a int declare @b int set @a = 1 set @b = 2 select @a | @b But this wont: declare @a varbinary...

Filed under: MSSQL, bitwise operators, sql, tsql, varbinary, numeric

Change mssql isolation level to read uncommitted data

Published 29 September 6 2:43 PM | Ramon Smits

Sometimes you are debugging an application and want to query the database while the database connection still has not committed (or rollbacked) the transaction. So you fire up the query analyzer just to find out that you cannot see the modifications yet...

Filed under: Development, Transactions, MSSQL