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 //修改表名