Can we genarate script of image column of a table in sql server 2008

  • hi,

    well is it possible to generate script of image table in a db

    all suggestion are welcome

  • Ivan Mohapatra (9/9/2011)


    hi,

    well is it possible to generate script of image table in a db

    all suggestion are welcome

    Can you please clarify what is "image table"?

  • You can to use an application programming language, e.g. one of the .NET languages, to write the binary data selected from the table to a file.

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

  • hi,image table means the column of that table where image datatype is set.

    is it clear or what more u want to know about image table.

  • Yes, you can. Cast the image column(s) to/from varbinary(max).



    Ole Kristian Velstadbråten Bangås - Virinco - Facebook - Twitter

    Concatenating Row Values in Transact-SQL[/url]

  • Can u send me the entire query to genrate the script

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply