数据库创建临时表:
IF not exists (select * from sysobjects where id = object_id(N'temp_inventory') and type='U')
select * into temp_inventoryfrom inventory
语句解释:
1、IF not exists (select * from sysobjects where id = object_id(N'temp_inventory') and type='U'):
判断将要创建的表名(temp_inventory)是否存在
temp_inventory:将要创建的临时表
sysobjects:系统对象表
2、select * into temp_inventory from inventory :创建临时表