给段参考的
w_dm.create_delete_temptable //窗体.TADOquery
with w_dm.create_delete_temptable do
begin
close;
sql.text:= 'if exists (select * from sysobjects where id = object_id(N' + '''[dbo].[' + temptable + ']''' + ') and OBJECTPROPERTY(id, N' + '''IsUserTable' + ''') = 1)'
+ ' drop table [dbo].[tblstoretemp]'
+ ' CREATE TABLE [dbo].[' + temptable + '] ('
+ ' [id] [decimal](18, 0) IDENTITY (1, 1) NOT NULL ,'
+ ' [goodsname] [varchar] (50) NULL ,'
+ ' [number] [decimal](18, 0) NULL ,'
+ ' [price] [money] NULL ,'
+ ' [unit] [varchar] (4) NULL ,'
+ ' [money] [money] NULL ,'
+ ' [state] [varchar] (16) NULL ,'
+ ' [sellnumber] [decimal](18, 0) NULL ,'
+ ' [cost] [money] NULL ,'
+ ' [sellmoney] [money] NULL ,'
+ ' [goodsid] [char](10) NULL ,'
+ ' [zhihao] [varchar] (12) NULL,'
+ ' [depname] [varchar] (20) NULL,'
+ ' [depid] [int] NULL'
+ ' ) ON [PRIMARY]';
execsql;
end;