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...
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...