Upload File on sql serverDB

• sam_btech

  Newbie

  Points: 3

  More actions

  June 17, 2008 at 11:16 pm

  #192706

  i am new to sql server 2005. i want upload file in sql server.

  i am use varchar it will store string.

  pls reply data type

• Andras Belokosztolszki

  SSC-Insane

  Points: 22031

  More actions

  June 18, 2008 at 1:53 am

  #830246

  sam_btech (6/17/2008)

  ---

  i am new to sql server 2005. i want upload file in sql server.

  i am use varchar it will store string.

  pls reply data type

  assuming the file is on the server, and the SQL Server has permissions to access it:

  DECLARE @filecontent VARCHAR(MAX)

  SELECT @filecontent = result.BulkColumn

  FROM OPENROWSET(BULK 'z:\ljkasd.txt', SINGLE_CLOB) AS result

  SELECT @filecontent

  Regards,

  Andras

  ---

  Andras Belokosztolszki, MCPD, PhD
  GoldenGate Software