Sql Server Datatype being depricated, what is the preferred Datatype to use when storing to Sql Server?

Last post 08-29-2012, 2:48 PM by Kenneth. 1 replies.
Sort Posts: Previous Next
  •  08-08-2012, 10:15 AM 74376

    Sql Server Datatype being depricated, what is the preferred Datatype to use when storing to Sql Server?

    The Sample Sql Server code provided is using the "image" Datatype.  When researching this in Sql Server 2008, this Datatype is listed as one that is being depricated in the future.
     
    What is the preferred Datatype to use instead?
     
    Thanks
    Filed under:
  •  08-29-2012, 2:48 PM 74515 in reply to 74376

    Re: Sql Server Datatype being depricated, what is the preferred Datatype to use when storing to Sql Server?

    Hi RobN,

     

    In sql  2008, you can use type VARBINARY(MAX)  to replace the Image type. 

     

    Regards,

     

    Ken 

View as RSS news feed in XML