【转】Sybase几个基本应用

设置步长，不能自动实现，自动时候，步长只能够为1  
1> create table testS(id numeric(10,0) identity , name varchar(50))
2> go

1> insert into testS values ('zhaixf')
2> go

1> select * from testS
2> go
id            name                                              
------------- ------------
             1 zhaixf     
注：identity后面要加空格，不能直接跟‘,’。
        1> insert into testS values (2,'zhaixf')
       2> go       

非法，不被允许         



declare @date1 datetime
declare @date2 datetime
select @date1=getdate()
--测试语句
select @date2=getdate()
select datediff(millisecond, @date1, @date2)
--结果是毫秒数


创建索引：
create [clustered|noclustered] index indexname
        on [[database.]owner.]tablename
        (columnname [asc|desc] [, columnname [asc|desc]]...)
        [with {
                {fillfactor = pct|max_row_per_page=num_rows},
                reservepagegap = num_pages,
                consumers = x, ignore_dup_key, sorted_data,
                ...}]
        [on segmentname]

创建存储过程：
create procedure [owner.]procedure_name[;number]
        [[(]@parameter_name
        [, @parameter_name....]
        [with recompile]
        as {sql_statements | external name dll_name}

drop proc orderproc

for example:
create procedure showind @tabname varchar(30)
as
   select sysobject.name, sysindexes.name, indid
      from sysindexes, sysobjects
      where sysobjects.name=@tabname
      and sysobjects.id=sysindexes.id


新增字段：
ALTER TABLE [表名] ADD [字段名] NVARCHAR (50) NULL

删除字段：
ALTER TABLE [表名] DROP COLUMN [字段名]
----------------------------------------------------------
alter table tab_role add is_default tinyint null
0为默认


ALTER table customer add Gender char(1)

ALTER table customer change Address Addr char(50)  //不好用

ALTER table customer modify Addr char(30)

ALTER table customer drop Gender

select * into destTbl from srcTbl

insert into destTbl(fld1, fld2) select fld1, 5 from srcTbl

update a set pic=(select pic from b) where a.name=b.name
//更新多行
update tab_hgwcustomer set serv_type_ids = serv_type_id

sp_rename old_name,new_name         //修改表名

<script></script>