Sybase命令研究

作者：雷智民
日期：2006-9-12
目的：解决系统从Oracle到Sybase的迁移

命令纵览：

C:\Documents and Settings>isql -help
Syntax Error in '-help'.
usage: isql [-b] [-e] [-F] [-p] [-n] [-v] [-X] [-Y] [-Q]
        [-a display_charset] [-A packet_size] [-c cmdend] [-D database]
        [-E editor [-h header [-H hostname [-i inputfile]
        [-I interfaces_file] [-J client_charset] [-K keytab_file]
        [-l login_timeout] [-m errorlevel] [-M labelname labelvalue]
        [-o outputfile] [-P password] [-R remote_server_principal]
        [-s col_separator] [-S server_name] [-t timeout] [-U username]
        [-V [security_options]] [-w column_width] [-z localename]
        [-Z security_mechanism]

登录到指定ip地址的数据库里面：
isql -H 192.168.3.143 -U sa -P zvfims-D icms -S LEIZHIMIN

C:\Documents and Settings>isql -H 192.168.3.143 -U sa -P zfvims -D zfv -S LEIZHIMIN

接着创建表进行测试：
1> create table test(mom varchar(20))
2> insert into test values('aaa')
3> insert into test values('bbb')
4> insert into test values('ccc')
5> select * from test
6> go
(1 row affected)
(1 row affected)
(1 row affected)
 mom
 --------------------
 aaa
 bbb
 ccc

(3 rows affected)
1>

Sybase数据库的弊病，不支持分号语句结尾，执行sql要用go，好贱啊。。。