views:

11

answers:

0

Hi all,

with a TFS 2008 Teambuildtype we create a ClickOnce Setup for a review version of our application. Within this Teambuildtype we create an initial database with some data to start directly with tests.

Now i need to put some binary data in our sql script insert files (Wordfiles).

How can i create a initial script with the binary data ? I can't put the binary string into a script or?

Thanks a lot

Edit:

Found a solution with OpenRowset

INSERT INTO TestTable (Doc) SELECT * FROM OPENROWSET(BULK N'C:\File.jpg', SINGLE_BLOB) as ImageToInsert