Answer / Iqra

To fetch data from FTP using a SQL Server stored procedure, you can use the OPENQUERY function. Here's an example of a simple stored procedure:

```sql
CREATE PROCEDURE dbo.GetDataFromFTP
AS
BEGIN
DECLARE @SQL NVARCHAR(MAX)
SET @SQL = 'SELECT * FROM OPENQUERY(FTP, ''SELECT * FROM file.txt'')'
EXEC (@SQL)
END
```
This procedure assumes you have a connection to an FTP server named 'file' and the data is stored in a text file named 'txt'.

Code for using a Hot Key in an ActiveX Control?

1 Answers  

Code for Adding Scripting Support to an Application?

1 Answers  

How can a procedure fetch data from FTP? I need a general code for this..

1 Answers   Infosys,

iam getting keyword or delimiter error while executing ICETOOL,provide me solution.

1 Answers  

How to access oralce10g data from server to client in LAN?

1 Answers