Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 Transact-SQL (2005)
 Insert Binary Data with Insert Statement

Author  Topic 

azerbaycanli113
Starting Member

5 Posts

Posted - 2010-11-01 : 03:21:22
Hi geeks. I need need help with inserting binary data into a varbinary(max) field. I've never done this before. So I want to write a stored procedure for it. Would it be something like:
INSERT INTO AZS_FOLDERDET(FOLDERDET) VALUES (.........).

So I don't know what to write in the dotted field.

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2010-11-01 : 12:46:14
see

http://weblogs.sqlteam.com/peterl/archive/2007/09/26/Insert-binary-data-like-images-into-SQL-Server-without-front-end.aspx

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/

Go to Top of Page
   

- Advertisement -