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