SmartEmotion的专栏

Create function f_GetMaxCyrs(@rs1 int,@rs2 int ,@rs3 int ,@rs4 int) returns intasbegin declare @rstmp int if @rs1 >= @rs2 set @rstmp = @rs1 else set @rstmp = @rs2 if @rstmp >= @rs3 s

Create function f_GetPy(@str nvarchar(4000)) returns nvarchar(4000) as begin declare @strlen int,@re nvarchar(4000) declare @t table(chr nchar(1) collate Chinese_PRC

select dwbh,count(dwbh) as bhsl from t_bzjhzb where jynd = '2011'group by dwbh having count(dwbh) > 1