:NOSERVER
ECHO BCPIn.bat Creater error: Please give the Sybase Database server name. >> CreateInBCP.log
ECHO BCPIn.bat Creater error: Please give the Sybase Database server name.
GOTO EXAMPLE
:NOUSER
ECHO BCPIn.bat Creater error: Please give the USER name. >> CreateInBCP.log
ECHO BCPIn.bat Creater error: Please give the USER name.
GOTO EXAMPLE
:NOPASSWORD
ECHO BCPIn.bat Creater error: Please give the PASSWORD. >> CreateInBCP.log
ECHO BCPIn.bat Creater error: Please give the PASSWORD.
GOTO EXAMPLE
:EXAMPLE
ECHO The usage is: CreateInBCP USERNAME PASSWORD SERVERNAME >> CreateInBCP.log
ECHO The usage is: CreateInBCP USERNAME PASSWORD SERVERNAME
GOTO END
:END
第二步:做如下sql脚本文件:SelectInBCP.sql
set nocount on
use 数据库
go
select "bcp 数据库.用户名." + name + " in " + name + ".bcp -U 用户名 -P 密码 -S 服务器名 -c " + '-t " #### " -r "|\n" '
from sysobjects where type="U"
go
quit
go
前面朋友说得对,写一个教本文件bcp.sql,内容如下:
select 'bcp database..' + name + ' out ' + '/data/' + name + '.out' + ' -n -Sservername -Usa -Pxxx' from database..sysobjects where type = 'U'
前面不是有吗。。
select 'bcp database..' + name + ' out ' + '/data/' + name + '.out' + ' -n -Sservername -Usa -Pxxx' from database..sysobjects where type = 'U'