jyxxb20040515184313.sql

sql版功能齐全

--表'jyxxb'的结构
  if exists (select * from sysobjects where id = OBJECT_ID('jyxxb') and OBJECTPROPERTY(id, 'IsUserTable') = 1) DROP TABLE jyxxb
  CREATE TABLE jyxxb(UserID numeric null,TSBH nvarchar (13) null,JDate smalldatetime null,HDate smalldatetime null,LastDate smalldatetime null,Num int null,)
--表'jyxxb'的数据
  insert into jyxxb(UserID,TSBH,JDate,HDate,LastDate,Num) Values(1111111111,'1234567890123','2003-12-18','2000-1-1','2003-12-25',2)
  insert into jyxxb(UserID,TSBH,JDate,HDate,LastDate,Num) Values(1111111111,'1234567890123','2003-12-18','2000-1-1','2003-12-25',3)
  insert into jyxxb(UserID,TSBH,JDate,HDate,LastDate,Num) Values(2222222222,'1234567890123','2004-2-23',null,'2004-3-1',2)
  insert into jyxxb(UserID,TSBH,JDate,HDate,LastDate,Num) Values(100000001,'1234567890123','2004-5-13','2004-5-13','2004-5-23',null)
  insert into jyxxb(UserID,TSBH,JDate,HDate,LastDate,Num) Values(100000001,'2222222222222','2004-5-13',null,'2004-5-23',null)