Mie imi merge:

DECLARE
 @cmd  sysname,
 @var  nvarchar(100),
 @destinatie nvarchar(50)

set @var='Test'
set @destinatie='C:\test.txt'
SET @cmd = 'echo ' + @var + ' > '+@destinatie
EXEC master..xp_cmdshell @cmd
GO

 

---

Cristian Andrei Lefter, SQL Server MVP
MCT, MCSA, MCDBA, MCAD, MCSD .NET,
MCTS, MCITP - Database Administrator SQL Server 2005
http://sqlserver.ro