å建
create function [dbo].weizhi
(@scode varchar(10))
Returns varchar(10)
As
Begin
Declare @len int
Declare @t varchar(10)
select @len=len(@scode)
set @t=''
if @len%2=1
begin
set @t=SUBSTRING(@scode,@len/2+2,@len/2)+SUBSTRING(@scode,@len/2+1,1)+SUBSTRING(@scode,1,@len/2)
end
else if @len%2=0
begin
set @t=SUBSTRING(@scode,@len/2+1,@len/2)+SUBSTRING(@scode,1,@len/2)
end
return @t
end
æ§è¡æµè¯
select dbo.weizhi('1230456')
select dbo.weizhi('123456')
追é®å¯ï¼è¿ä¸ªæ¹æ³æå·²ç»ååºæ¥äºãç°å¨çè¦æ±æ¯ä¸è¦å¤æç¨ä¸æ¡è¯å¥å®ç°ææå¯è½è¾å
¥çåæ°ã
追çalter function [dbo].weizhi
(@scode varchar(10))
Returns varchar(10)
As
Begin
Declare @len int
Declare @t varchar(10)
select @len=len(@scode)
set @t=''
select @t=case when @len%2=1
then SUBSTRING(@scode,@len/2+2,@len/2)+SUBSTRING(@scode,@len/2+1,1)+SUBSTRING(@scode,1,@len/2)
else SUBSTRING(@scode,@len/2+1,@len/2)+SUBSTRING(@scode,1,@len/2) end
return @t
end
é£å°±æifæ¢æcase when
追é®è¯¶åï¼å¥½æºæºåã
æ©äººåï¼å¤ªæè°¢äºï¼ï¼
追çæ±é纳