sqlsevert-sql判断输入的数字重复出现的次数-mysql教程

Select

Case

When a is not null then a

When b is not null then b

When c is not null then c

When d is not null then d

Else ''

End 列名

From Table Name

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

（生成当天最大顺序编号）

substring(convert(varchar(8), getdate(), 112), 1, 8)

+'568'

+ replicate('0', 4-len(max_ContractNo)) --以指定的次数重复字符表达式

+ cast(max_ContractNo as varchar(4))

from (select

case

when substring(max(My_ContractNo), 12, 4) is null then '1'

else cast(cast(substring(max(My_ContractNo), 12, 4) as bigint) + 1 as varchar(8))

end max_ContractNo

from UserContractNo

WHERE datediff(Day,Adddate,getdate())=0

) s

CREATE TABLE [UserContractNo](

[Id] [int] IDENTITY(1,1) NOT NULL,

[ApplyUserDetailID] [int] NOT NULL,

[My_ContractNo] [varchar](50) COLLATE Chinese_PRC_CI_AS NOT NULL CONSTRAINT [DF_UserContractNo_My_ContractNo] DEFAULT (''),

[AddDate] [datetime] NOT NULL CONSTRAINT [DF_UserContractNo_AddDate] DEFAULT (getdate()),

[Remarks] [varchar](50) COLLATE Chinese_PRC_CI_AS NOT NULL CONSTRAINT [DF_UserContractNo_Remarks] DEFAULT (''),

CONSTRAINT [PK_UserContractNo] PRIMARY KEY CLUSTERED

([Id] ASC) ON [PRIMARY]

) ON [PRIMARY]