SA Developer .NET

Hi,

 I would like to pass a filename to a proc and let the proc handle image storage and from a physical location. Please advise?

 

Thanks,

JK.

Something like so should work:

CREATE PROCEDURE ImportFile
      @Filename NVARCHAR(512)
AS
      DECLARE @Sql NVARCHAR(512)
      SET @Sql = 'INSERT INTO bindata(data)
                  SELECT
                        *
                  FROM
                        OPENROWSET(BULK ''' + @Filename + ''', SINGLE_BLOB)'

      EXEC (@sql) 

---

Why go against tradition when we can admit defeat, live in decline, be the victim of our own design?
http://dotnet.org.za/calmyourself