DECLARE @IsFileExists INT
EXEC Master.dbo.xp_fileexist 'D:\TechnoThirsty.txt', @IsFileExists OUT
IF @IsFileExists = 1
BEGIN
PRINT 'File Exists...'
END
ELSE
BEGIN
PRINT 'File Does not Exists...'
END
asp.net,c#.net, MVC, WPF, WCF, JavaScript, JQuery, SQL Server, Interview Q&A
DECLARE @IsFileExists INT
EXEC Master.dbo.xp_fileexist 'D:\TechnoThirsty.txt', @IsFileExists OUT
IF @IsFileExists = 1
BEGIN
PRINT 'File Exists...'
END
ELSE
BEGIN
PRINT 'File Does not Exists...'
END