在SYBASE应用系统中使用临时表
Using Temporary Table in SYBASE Application System
-
摘要: 临时表是tempdb数据库中的一种特殊数据库表,它用来暂存中间结果数据。在数据库应用系统中,有效地利用临时表可减少系统开销和提高系统的运行速度。文中介绍了在SYBASE数据库应用系统中使用临时表的意义与创建方法;阐述了临时表的一般应用方法;最后给出应用临时表的实例。Abstract: The temporary table is a kind of specific database table which can be used to store intermediate data in the tempdb database. Using temporary table effectively can lessen the system load and promote the system executive speed in database application system. This paper introduces significance and method of creating temporary table in SYBASE database application system. The general application method of temporary table is also described. At last an example is given.