tsjbxx20040515184313.sql

来自「图书管理系统 SQL版 代码中的数据库不用任何设置」· SQL 代码 · 共 10 行

--表'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')