>Here is how I can re-produce the problem
>
>declare @DefaultPicture nvarchar(max)
>set @DefaultPicture = null
>create table #test (Def varbinary(max) null)
>set @DefaultPicture = convert(varbinary(max),@DefaultPicture)
>insert into #test values (ISNULL(@DefaultPicture,0))
That is wrong.
First you declare @DefaultPicture as NVARCHAR and then you assign VARBINARY value to it.
declare @DefaultPicture VARBINARY(max)
set @DefaultPicture = null
create table #test (Def varbinary(max) null)
set @DefaultPicture = convert(varbinary(max),@DefaultPicture)
insert into #test values (ISNULL(@DefaultPicture,0))
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.
