File upload into sql server database

[RamamurthySodimalla]

Hi,
All

Please guide me , how to upload a file into Sql server database using Jsp page.

Thanks in Advance

[r035198x]

Hi,
All

Please guide me , how to upload a file into Sql server database using Jsp page.

Thanks in Advance

Have a look at the bulk insert command (You'll probably need to search SQL server resources rather than Java resources for it). Something like

[CODE=sql]BULK INSERT tableName
FROM 'filePath'
WITH
(
FIELDTERMINATOR = ...
ROWTERMINATOR = ...
) [/CODE]