Search Result

Collapse
2 results in 0.0015 seconds.
Keywords
Members
Tags
varbinary(max)
  •  
  • kunalk
    started a topic varbinary(max) field in sql server 2005 problems
    in SQL Server

    varbinary(max) field in sql server 2005 problems

    Code:
    CREATE TABLE Upload
(
uploadid INT IDENTITY(1,1) PRIMARY KEY,
cssid INT NOT Null FOREIGN KEY REFERENCES CourseSemSub(cssid),
teacherid VARCHAR(10) NOT NULL FOREIGN KEY REFERENCES Teacher(teacherid),
description VARCHAR(40),
video VARBINARY(MAX) NOT NULL
)
    I'm unable to execute the above create table statement. It is giving the following error.
    Msg 170, Level 15,...
    See more | Go to post
    • Gilad
      Guest started a topic from 'image' to 'varbinary(max)'
      in SQL Server

      from 'image' to 'varbinary(max)'

      Hi

      I moved to SQL Server 2005 (from 2000) and noticed there is a better
      variable to deal with binary arrays.
      I hava a table that hold 9 columns of images (BLOB). each array has a
      different size and can be larger than 4k.
      I've changed the column data type from image to varbinary(max).
      After the chnage, the size of the table grew from 22MB to 26MB.
      Any idea why? I though the new variable should be better....
      See more | Go to post
      Previous template Next
      Working...