d:
isql -U sa -P sa -d ysbknewbak -i exp4bk.sql -o exp4bk.bat -n -h-1 -w500 -b -s
call exp4bk.bat
exit
/* exp4bk.sql 使用 isql執行,exp4bk.sql內容如下*/
SET NOCOUNT ON
SELECT 'd:'
SELECT 'BCP ' + DBNAME + '.dbo.' + TABLENAME + ' OUT ' +
'd:\' + RTRIM(TABLENAME) + '.bcp -c -U intech -P intech -S ' +
RTRIM(SERVERNAME)
FROM N_BACKUP_TABLE
WHERE STATUS = 'Y'
SET NOCOUNT OFF
