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
