Shulou(Shulou.com)06/01 Report--

declare @fn nvarchar(max) = CONVERT(char(8),GETDATE(),112)+CONVERT(char(15),GETDATE(),114)set @fn ='D:\file\' +rtrim(replace(@fn,':','))+'.xls'SET @fn ='EXEC master.. xp_cmdshell'+'''bcp "select * from TOPLED2015.. COPTDLog1" queryout ' + @fn + ' -c -q -T''EXEC(@fn)/*BCP Usage:bcp {dbtable| query} {in | out | queryout |format} data file dbtable| query : table or result set in : importing data out : exporting data queryout : conditionally exporting data [-m Maximum number of errors] [-f Format File] [-e Error file] [-F first line] [-L Last line] [-b Batch Size] [-n Native Type] [-c character type] [-w Wide character type] [-N Keep non-text as native type] [-V file format version] [-q quoted identifier] [-C code page specifier] [-t field terminator] [-r line terminator] [-i input file] [-o Output file] [-a Packet Size] [-S Server Name] [-U User name] [-P Password] [-T Trusted Connection] [-v Version] [-R Allow Locales] [-k Leave blank] [-E Keep ID value] [-h"Load prompt"] [-x generate xml format file] */ --Export with conditional query, EXEC master.. xp_cmdshell 'bcp "select * from TEST.. Demo_A" queryout D:\Test\1.xls -c -q -T'EXEC master.. xp_cmdshell 'bcp "select * from TEST.. Demo_A" queryout D:\Test\1.xls -c -q -S". " -U"sa" -P"123123"'--All table data export EXEC master.. xp_cmdshell 'bcp TEST.dbo.Demo_A out D:\Test\1.xls -c -q -T'--Import data, table structure consistent EXEC master.. xp_cmdshell 'bcp TEST.. Demo_A in D:\Test\1.xls -T -c'--Resolve some error handling-- To allow advanced options to be changed.EXEC sp_configure 'show advanced options', 1GO-- To update the currently configured value for advanced options.RECONFIGUREGO-- To enable the feature.EXEC sp_configure 'xp_cmdshell', 1GO-- To update the currently configured value for this feature.RECONFIGUREGO

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.