B_gd_n[ ]Sahlean:

tebbaerty:

Microsoft Sql Server Management Studio 2005 . din cate observ exista campul BLOB dar vad ca sql 2005 nu il recunoaste

-------------------------------------------------------

INSERT INTO BLOBTest
  (BLOBName, BLOBData)
  SELECT 'First test file',
    BulkColumn FROM OPENROWSET(
      Bulk 'C:\temp\nextup.jpg', SINGLE_BLOB) AS BLOB

am citit in linkurile date de Dvs. si am testat si exemplul acesta.
fac insertul.
cand dau select coloana BulkColumn este goala.
Aveti vreo idee de ce? din cate observ nu se salveaza nimic.

SELECT @@VERSION ==

Microsoft SQL Server 2005 - 9.00.3042.00 (Intel X86)   Feb  9 2007 22:47:07   Copyright (c) 1988-2005 Microsoft Corporation  Express Edition on Windows NT 6.0 (Build 6001: Service Pack 1)

asta e versiunea mea.