摘要:
SELECT 'All' AS LABLE_NAME, NULL AS USER_NAMEUNION ALLSELECT USER_NAME AS LABLE_NAME, USER_NAME from dbo.USERS将ALL作为下拉列表的默认值这样判断User的时候可用USERNAME=ISNU... 阅读全文
摘要:
DATE_ENTERED >= dateAdd(hour,CONVERT(INT,@HOUR_FROM),dbo.fnDateOnly(@DATE)) AND DATE_ENTERED <= dateAdd(hour,CONVERT(INT,@HOUR_TO),dbo.fnDateOnly(@DAT... 阅读全文
摘要:
1.New一个dataset名为Hours2.SELECT 0 AS HOUR UNIONSELECT 1 AS HOUR UNIONSELECT 2 AS HOUR UNIONSELECT 3 AS HOUR UNIONSELECT 4 AS HOUR UNIONSELECT 5 AS HOUR ... 阅读全文