Search Result

Collapse
2 results in 0.0015 seconds.
Keywords
Members
Tags
varbinary(max)
  •  

  • 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)'

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