首页 > 代码库 > 索引 视图 游标

索引 视图 游标

索引:

不用扫描整个表就实现对数据快速访问的途径。

二进制类型不支持索引

视图:

从一个或多个基本表中导出所显示的表,是没有数据的虚表。

多表出一视图,一表出多视图,多表与一视图出一视图

游标:

所有数据库:行的次序无关,列的次序无关

select Code,Name,Brand_Name,Prod_Name,oil,Price from car

    join Brand on Car.Brand = Brand.Brand_Code

    join Productor on Productor.Prod_Code = Brand.Prod_Code

   

select * from viewcar

 

select * from chinastates where parentareacode=‘37‘

 

create view ShanDong

as

select * from chinastates where parentareacode=‘37‘

go

 

select * from shandong

 

insert into shandong(areacode,areaname,parentareacode,root,zone) values(‘3779‘,‘临淄‘,‘38‘,‘‘,‘‘)

 

select * from viewcar

insert into viewcar values(‘c222‘,‘鲁轻电动汽车‘,‘超强续行王‘,‘山东轻骑‘,‘0‘,‘5‘)

 

declare cur_car cursor scroll

for select name from Car where Name like ‘奥迪%‘

open cur_car

fetch first from cur_car

while @@FETCH_STATUS = 0

begin

    declare @name varchar(50)

    fetch next  from cur_car into @name

    --print @name

   

    if ltrim(left(@name,LEN(‘奥迪A4 07款‘)))=‘奥迪A4 07款‘

    begin

       fetch prior from cur_car into @name

       print @name

       fetch relative 2 from cur_car into @name

       print @name

    end

   

end

close cur_car

deallocate cur_car

 

索引 视图 游标