摘要：
create table test(Date varchar(50) null, Result varchar(50) null) insert into test values('1900-1-1','胜') insert into test values('1900-2-1','胜') insert into test values('1900-1-1','负') insert into ... 阅读全文
posted @ 2010-07-02 10:30
kevin_20131022
阅读(449)
评论(0)
推荐(0)
摘要：
代码 阅读全文
posted @ 2010-07-02 10:10
kevin_20131022
阅读(120)
评论(0)
推荐(0)
摘要：
TABLE [Test] ( [id] [int] IDENTITY (1, 1) NOT NULL , [name] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL , [subject] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL , [Source] [numeric](18, 0) NULL ... 阅读全文
posted @ 2010-07-02 09:45
kevin_20131022
阅读(2646)
评论(0)
推荐(0)
摘要：
Select top 100 State,JoinState, (case when State=1 and Joinstate=0 then 2 when State=1 and JoinState=1 then 1 else 0 end) as usestate from UserInfo (2) select ID,Username,namer=(case when(sc... 阅读全文
posted @ 2010-07-02 09:41
kevin_20131022
阅读(178363)
评论(1)
推荐(2)
浙公网安备 33010602011771号