同一日期导在1个文件
declare @outdate char(8)
declare @sqlcmd varchar(500)
set @sqlcmd=''
declaremycursor cursor for
select convert(char(8),createdate,112) from table1 group by convert(char(8),createdate,112)
OPEN mycursor
FETCH NEXT FROM mycursor into @outdate
WHILE @@FETCH_STATUS = 0
begin
select @outdate
set @sqlcmd='bcp "select content from test.dbo.table1 where convert(char(8),createdate,112)='''+@outdate+'''" queryout d:\'+@outdate+'.txt -c -q -S 127.0.0.1 -U sa -P ***'
select @sqlcmd
exec master.dbo.xp_cmdshell @sqlcmd
FETCH NEXT FROM mycursor into @outdate
end
CLOSE mycursor
DEALLOCATE mycursor
|