Selasa, 23 September 2014

Using BCP Via CMD & Windows Authentication

BACK UP DATA TABLE SQL WITH BCP UTILITY DAILY (Comma AS Delimiter)
bcp "SELECT * FROM MASTER.dbo.TABLE_NAME WHERE [date] = '20140704'"
queryout C:\BCP_FILENAME_20140704 -SserverName -T -c -t\",\"

_T --> Windows Authentication

Tidak ada komentar:

Posting Komentar