Browse by Tags

Appending data to a sql text or ntext column

Published Fri, Jun 20 2008 1:52 PM | Ramon Smits

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

Filed under: sql, UpdateText

Mssql: Cannot use bitwise operators on varbinary or numeric

Published Mon, Feb 25 2008 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