How Do I Retrieve File From Perticular Drive Using Stoared Procedure?

I want stored procedure for retrieve list of files (*.BAK) from particular folder.

C#

Here I got the following Script ,Which gives me all Backup file within particular Folder.Its correct but i want only 3 Latest File .So If anyone have idea ,then give me.



IF OBJECT_ID('tempdb..#DirectoryTree') IS NOT NULL
DROP TABLE #DirectoryTree;

CREATE TABLE #DirectoryTree (
id int IDENTITY(1,1)
,subdirectory nvarchar(512)
,depth int
,isfile bit);

INSERT #DirectoryTree (subdirectory,depth,isfile)
EXEC master.sys.xp_dirtree 'D:\Sujata\SALESDBBackup',1,1;

SELECT *--,ROW_NUMBER()over (order by id desc)
FROM #DirectoryTree
WHERE isfile = 1 AND RIGHT(subdirectory,4) = '.BAK'
ORDER BY id desc;
ELSE

GO