tsjbxx20040515184313.sql

sql版功能齐全

--表'tsjbxx'的结构
  if exists (select * from sysobjects where id = OBJECT_ID('tsjbxx') and OBJECTPROPERTY(id, 'IsUserTable') = 1) DROP TABLE tsjbxx
  CREATE TABLE tsjbxx(TSBH nvarchar (13) not null,Class nvarchar (4) null,tsName nvarchar (60) null,Auther nvarchar (50) null,OutDate smalldatetime null,CBS nvarchar (50) null,Cost float null,TotalNum int null,LastNum int null,BZ nvarchar (255) null,)
--表'tsjbxx'的数据
  insert into tsjbxx(TSBH,Class,tsName,Auther,OutDate,CBS,Cost,TotalNum,LastNum,BZ) Values('1232222222222','0002','we','ret','2002-3-3','hsd',23,12,12,'sgdrgb')
  insert into tsjbxx(TSBH,Class,tsName,Auther,OutDate,CBS,Cost,TotalNum,LastNum,BZ) Values('1234567890123','0002','delphi','han','2003-9-22','tengxing',99.99,99,100,'ê?ò?±?o?êé￡?￡?')
  insert into tsjbxx(TSBH,Class,tsName,Auther,OutDate,CBS,Cost,TotalNum,LastNum,BZ) Values('2121211111111','0001','111111111111111','11111111','1980-1-1','11',1111111,1111111,1111111,'1')
  insert into tsjbxx(TSBH,Class,tsName,Auther,OutDate,CBS,Cost,TotalNum,LastNum,BZ) Values('2222222222222','0001','we','aew','2002-12-12','dfefsdg',56,78,77,'22')
  insert into tsjbxx(TSBH,Class,tsName,Auther,OutDate,CBS,Cost,TotalNum,LastNum,BZ) Values('3211233234333','0003','egsd','jfg','2003-9-9','dfxz',8,11,11,'kjghsdf')