bcp数据表导出

select 'bcp nmdb..'+name+' out '+name+'.txt   -c -r "123!@#$%^&*"  -t "*&^%$#@!321"  -Unb -Pningbo -Sbdw_nb' from sysobjects where type='U' and (name not like 'tra%'  or name in('traTypeInfo','traDataExplain')) and name not like 'nor%' and name not like 'TB/_TMP/_%'  escape '/'
and name not like 'z/_%' escape '/' and name  like '[^V][^W]%' and name like '%[^Tt][^Ee][^Ss][^Tt]%' and name  like '%[^Hh][^Ii][^Ss]' and name like '%[^h][^w]' and name not in ('alarm','alarmHis','balk','balkHis','balkDeal','dealBook','dealBookHis','dealEvent','departBalkForm','departBalkFormHis','detailCommand','specialCommand','eventInfo','report','softupgrade','softup_tra','softup_config','softup_config','onLoginHis','operation') order by name

bcp nmdb..syscolumns out syscolumns.txt   -c -r "123!@#$%^&*"  -t "*&^%$#@!321"  -Unb -Pningbo -Sbdw_nb     

                        
bcp nmdb..sysobjects out sysobjects.txt   -c -r "123!@#$%^&*"  -t "*&^%$#@!321"  -Unb -Pningbo -Sbdw_nb