ljz9425的专栏

<br />点是否在圆内：<br /> <br /><br />select *<br />  from table a<br /> where SQRT(power(a.LONGITUDE - 116.3676095557983, 2) +<br />            power(a.LATITUDE - 39.913205912837014, 2)) <=<br />       0.039790863734664776<br /> <br />点是否在多边形内：<br /> <br /> <br

Select CONVERT(varchar(100), GETDATE(), 0): 07 16 2012 10:57AM Select CONVERT(varchar(100), GETDATE(), 1): 07/16/12 Select CONVERT(varchar(100), GETDATE(), 2): 12.07.16 Select CONVERT(varchar(10