Ò»¸öSQLСÎÊÌâ¡£ - .NET¼¼Êõ / C#

ÎÒµÄÊý¾Ý¿âÖÐÓÐ
0000-0000-0000-1026262
0000-0000-0000-1026263
0000-0000-0000-1026264
0000-0000-0000-1026265
0000-0000-0000-1026266
0000-0000-0000-1026267
0000-0000-0000-1026268
0000-0000-0000-1026269
0000-0000-0000-1026270
0000-0000-0000-1026271
0000-0000-0000-1026274
0000-0000-0000-1026275
0000-0000-0000-1026276
0000-0000-0000-1026277
0000-0000-0000-1026278
0000-0000-0000-1026279
0000-0000-0000-1026280
0000-0000-0000-1026281ÕâÑùµÄÊý¾Ý
»¹ÓÐÁÙʱµÄ
TMP1111-1111-1111-1111115
TMP1111-1111-1111-1111116
TMP1111-1111-1111-1111117¼ÙÈçÎÒÏÖÔÚÓÐÒ»¸öÁÙʱµÄ
TMP1111-1111-1111-1111117ÎÒÏëµÃµ½

TMP1111-1111-1111-1111114
ÔõôµÃµ½
´æ´¢¹ý³ÌÔõôд°¡£¡
ÎÒÊÇС²Ë
ÎÒÃ÷°×ÊÇÏÈÈ¥µôTMPºÍ- ת³ÉÊý×Ö¼õÒ»
µ«ÊÇÔõô²éµ½TMP1111-1111-1111-1111115°¡
Ë­ÄÜ°ï°ïÎÒ£¡£¡£¡
ÒÑÓнá¹ûÂíÉϽáÌù

---

ÄãûÓÐÃèÊöÇå³þ£¬TMP1111-1111-1111-1111114ת»»³ÉÊý×ÖÄܷŵÃÏÂô£¿

---

http://hi.baidu.com/joonylee/blog/item/ad06d21d0269b08086d6b623.html

---

SQL code:

declare @temp varchar(30),@num bigint,@result varchar(30)
select @temp=replace('TMP1111-1111-1111-1111115','-','')
select @temp=replace(@temp,'TMP','')
select @num=convert(bigint,@temp)
set @num=@num-1
set @temp=convert(varchar(30),@num)
set @result=substring(@temp,1,4)+'-'
set