摘要:
if exists (select * from sysobjects where type='P' and name=N'P_DeleteAllData' ) drop procedure P_DeleteAllData go CREATE PROCEDURE P_DeleteAllData as 阅读全文
摘要:
NewID为新建Guid的内置函数,into #TempAMajor 则为新建的临时表 select top 4 *,NewID() as RandomId into #TempAMajor from QMCS_User 判断是否有此缓存表,有则删除 IF OBJECT_ID(N'tempdb.db 阅读全文
摘要:
1.判断年月日是否相等select * from table where cast(convert(varchar(10), 时间字段, 120) as datetime)='2010-10-01'判断逻辑:通过convert函数现将时间字段中年月日截取出来,然后利用cast函数转化为datetim... 阅读全文
摘要:
今天的所有数据:select * from 表名 where DateDiff(dd,datetime类型字段,getdate())=0昨天的所有数据:select * from 表名 where DateDiff(dd,datetime类型字段,getdate())=17天内的所有数据:selec... 阅读全文
摘要:
前台方式第一种方式:1 var proj = new OpenLayers.Projection("EPSG:4326");2 var point = new OpenLayers.LonLat(-68, 42);3 point.transform(proj, map.getProjectionOb... 阅读全文