tebbaerty:Ma scuzati exista date in BlobData numai ca nu puteam sa le vad eu .... am dat un copy paste pe field si am vazut ca sunt acolo. :D .
dar daca am un video format avi mpeg sau orice alt format cum il salvez si il iau din baza de date . documentele specificate sunt doar pentru imagini
Import >INSERT INTO BLOBTest (BLOBName, BLOBData)
SELECT 'Second test clock.avi', BLOB.BulkColumn
FROM OPENROWSET(BULK 'c:\windows\clock.avi', SINGLE_BLOB) AS BLOB
Export>C:\Program Files\Microsoft SQL Server\MSSQL\Binn>textcopy /S server /D bazadedate /T BLOBTest /C BLOBData
/W " WHERE BLOBName = 'Second test clock.avi' " /F c:\ceas.avi /O
TEXTCOPY Version 1.0
DB-Library version 8.00.194
Type your login:
Type your password:
Data copied out of SQL Server image column into file 'c:\ceas.avi'.
Utilitarul TextCopy il poti gasi in SQL2000 in directorul
C:\Program Files\Microsoft SQL Server\MSSQL\Binn
Ref:
http://www.databasejournal.com/features/mssql/article.php/1443521+
TextCopy in SQL 2005+
Save/Retrieve Image From SQL Server Database Using Ado 2.5 Stream ObjectCateva idei:
[1]
http://highscalability.com/flickr-architecture[2]
http://highscalability.com/youtube-architecture