Today I came accross a problem where nvarchar data got larger than the maximum that can be stored in a record. I had to convert to a ntext column and append the data to it. I quickly found out that I needed to use the UPDATETEXT function in combination...
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...