摘要:
SELECT CASE WHEN GROUPING(FDeptNu)=1 THEN 2 ELSE 0 END AS FDeptNu_Grouping,FDeptNu AS FDeptNu_NOGrouping,CASE WHEN GROUPING(FDeptNa)=1 THEN 2 ELSE 0 E 阅读全文
摘要:
Select CONVERT(varchar(100), GETDATE(), 0): 05 16 2006 10:57AM Select CONVERT(varchar(100), GETDATE(), 1): 05/16/06 Select CONVERT(varchar(100), GETDA 阅读全文