lsztable.lsz

这是一个基于COM的数据库访问技术

  select * from TestTable
  
  delete from TestTable where bm='10002'
 update TestTable Set Salary=665666.5536 where bm='10003'


 --Drop Table TestTable
 Create Table TestTable
 ( 
   Bm varchar(20)  not null ,
   Name Varchar(50) null ,
   Address Varchar(50) null ,
   Old  int null ,
   Salary numeric(8,2)  null,
   Birth Date  null,
   Birth2 DateTime null
 )
   
 
  insert into TestTable(bm,name,Address,old,Salary,birth,birth2) values('10002','罗世振2','广东深圳2',203,6666.55,'2003-12-20','2003-12-31 20:12:23.135465')

  insert into TestTable(bm,name,Address,old,Salary,birth,birth2) values('10003','罗世振3','广东深圳3',203,665666.58,'2003-12-03','2003-12-03 20:12:23')

insert into TestTable(bm,name,Address,old,Salary,birth,birth2) values('10004','罗世振4','广东深圳4',203,665666.54,'2003-12-04','2003-12-04 20:12:23')

insert into TestTable(bm,name,Address,old,Salary,birth,birth2) values('10005','罗世振5','广东深圳5',203,665666.05,'2003-12-05','2003-12-05 20:12:23')

insert into TestTable(bm,name,Address,old,Salary,birth,birth2) values('10006','罗世振6','广东深圳6',203,665666.06,'2003-12-06','2003-12-06 20:12:23')