Difference between revisions of "Data Export from MS SQL Server"
Jump to navigation
Jump to search
(Created page with " declare @sql varchar(8000) SELECT @sql =' bcp "select u.BADGENUMBER EMPLOYEE , CONVERT(VARCHAR, CHECKTIME,110) CHECK_DATE, CONVERT(VARCHAR, CHECKTIME,108) CHECK_TIME,c.CHE...") |
|||
Line 1: | Line 1: | ||
− | + | <pre> | |
declare @sql varchar(8000) | declare @sql varchar(8000) | ||
Line 6: | Line 6: | ||
exec master..xp_cmdshell @sql | exec master..xp_cmdshell @sql | ||
+ | </pre> |
Revision as of 14:04, 6 June 2017
declare @sql varchar(8000) SELECT @sql =' bcp "select u.BADGENUMBER EMPLOYEE , CONVERT(VARCHAR, CHECKTIME,110) CHECK_DATE, CONVERT(VARCHAR, CHECKTIME,108) CHECK_TIME,c.CHECKTYPE from [att_db].[dbo].[CHECKINOUT] c, att_db.dbo.USERINFO u where u.USERID=c.USERID AND c.CHECKTIME > DATEADD(MONTH, -1, GETDATE())" queryout D:\TOM-FILE\Attendance-Data.txt -t -c -T' exec master..xp_cmdshell @sql