Reading text from a stored procedure.

[MarkWilliamson]

Another rookie question..

I have a file x.txt which basically contains a file listing of a directory. I just want to be able to open the file and read each line individually from a stored procedure. Is there a simple way to accomplish this ?

Thanks in advance to all who reply !

 

[JayKusch]

I would first create a temp table to handle each line of text in your x.txt file ...

CREATE TABLE #ReadFile (
	[RF_Key] [int] IDENTITY (1, 1) NOT NULL ,
	[LineOfText] [varchar] (2000) NULL
) ON [PRIMARY]

I would then run this code to populate the temp table w/ the x.txt file. 1 record will be created for each line in the file.

INSERT INTO #ReadFile EXEC Master.dbo.xp_cmdshell 'type C:\x.txt'

Now you can use a WHILE statement to read each record/text line by incrementing the RF_key from 1 by one.

You can also run a SELECT just to see what the table will look like ...

SELECT * FROM #ReadFile

Thanks

J. Kusch