Difference between revisions of "Data Export from MS SQL Server"

From SmartHCM Wiki
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