ТЕМА:

CREATE PROC write_to_file
  @msg VARCHAR(100),
  @file VARCHAR(100),
  @overwrite BIT = 0
AS

/*
  Tested on: SQL Server Version 7.0, 2000
  Remarks: You should have permissions required through access file system through xp_cmdshell
           See SQL Server Books Online for xp_cmdshell if you are having problems with this procedure
*/

BEGIN
	SET NOCOUNT ON
	DECLARE @execstr VARCHAR(255)
	SET @execstr = RTRIM('echo ' + COALESCE(LTRIM(@msg),'-') + CASE WHEN (@overwrite = 1) THEN ' > ' ELSE ' >> ' END + RTRIM(@file))
	EXEC master..xp_cmdshell @execstr
	SET NOCOUNT OFF
END