无标题1.sql

自己做的一个例子

--Insert Into AsSet (sID, sName) Values('000','直接Insert')
--Update AsSet Set OutID='用Update更新' Where sID='000'
--Select * From AsSet

--Select dDate, Convert(Real,dDate) From AsSet



Select Convert(DateTime,0.567), Convert(Real, Convert(DateTime,'1900-02-01') )

Select Convert(DateTime,'1900-01-02'), Convert(DateTime,'1900-1-2'), Convert(DateTime,'1900.1.2')

--AdoQuery1.Open  AdoQuery.ExecSQL
--DataSet