Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

sqlÖÐÊý¾Ý¿â×Ö¶ÎÀàÐÍÎÊÌâ

±ÈÈç˵idºÅΪÖ÷¼üÓÃ×ÔÔö±íʾ´Ó0001¿ªÊ¼ »¹ÓÐÍâ¼ü´Ó001¿ªÊ¼¹ØÁªÁíÒ»¸ö±í ÈçºÎ´´½¨ÕâÁ½¸ö×Ö¶Î
дһ¸öº¯Êý£¬È¡×î´ó¼Ó1²¢¸ñʽ»¯£¬È»ºóµ±×÷ȱʡÀ¦°óÔÚIDÁÐÉÏ

Íâ¼ü¹ØÁªÖ±½ÓÁª»ú°ïÖú¾ÍÐÐ



ÒýÓÃ
дһ¸öº¯Êý£¬È¡×î´ó¼Ó1²¢¸ñʽ»¯£¬È»ºóµ±×÷ȱʡÀ¦°óÔÚIDÁÐÉÏ

Íâ¼ü¹ØÁªÖ±½ÓÁª»ú°ïÖú¾ÍÐÐ



Äܸø³öÒ»¸öʾÀýô ÎÒÊǸö³õѧÕß Õâ½âÊÍÈÃÎҷѽâ


ÒýÓÃ
SQL codecreatetable test(idchar(5)primarykey ,colvarchar(4))gocreatefunction uf_maxid()returnschar(5)asbegindeclare@maxidvarchar(5)select@maxid=max(id)from testif@maxidisnullset@maxid='00000'returnright('00000'+ltrim(cast(@maxidasint)+1),5)endgoaltertable testaddCONSTRAINT column_e_defaultDEFAULT dbo.uf_maxid()for idgoinsertinto test(col)select'test'insertinto test(col)select'test'insertinto test(col)select'test'select*from test/*
id col
----- ----
00001 test
00002 test
00003 test

£¨ËùÓ°ÏìµÄÐÐÊýΪ 3 ÐУ©*/droptable testdropfunction uf_maxid

ллÁË ÎÒÑо¿Ï»ØÍ·½áÌù¸øÄã·Ö


Ïà¹ØÎÊ´ð£º

sqlת»»ÎÊÌ⣬¼±£¡ - ÉçÇøÖ§³Ö / ¡¶³ÌÐòÔ±¡·ÔÓÖ¾

select convert(varchar(50),cast(convert(numeric(18,2),1275674000000/100000000)as real))+'ÒÚ'
select cast(convert(numeric(18,2),1275674000000/100000000)as real)
ΪʲôÉÏÒ»¸öÓÃvarcharת»»ºó¾ÍÖ»±£ÁôÁËÒ ......

¹ØÓÚSQLSERVERµ×²ãÎÊÌâ - MS-SQL Server / ÒÉÄÑÎÊÌâ

ÇëÎÊһϣ¬ÍâÍøÁ½Ì¨SQLSERVERʵÀýÊý¾Ý´«Ê䣬ÓÐûÓвÉÓÃÊý¾ÝѹËõºÍ¼ÓÃÜ¡£Ñ¹Ëõ±ÈÊǶàÉÙ£¬¼ÓÃÜÊÇʲô¼ÓÃÜËã·¨£¿Ïà¹ØÎĵµÄÄÀï¿ÉÒÔÕÒµ½£¿Ð»Ð»


ÎÒÒ²ÏëÖªµÀ£¡¹Ø×¢´ËÌù£¡

¹Ø×¢¡«¡«

Êý¾Ý¿â´óÅ£¶¼ÄÄÈ¥Á˰¡£¿
......

sqlÐÔÄÜÇóÖú - MS-SQL Server / ÒÉÄÑÎÊÌâ

³¡¾°ÈçÏ£º
¿Í»§°Ñ±¸·ÝºÃµÄÊý¾Ý¿â£¬·¢¸øÎÒ£¬ÎÒÔÚ±¾»ú»¹Ô­ºó£¬ÔËÐÐдºÃµÄ´æ´¢¹ý³Ì£¬±È½Ï¿ì£¬²¢ÇÒÔÚʵʩÄDZßÔËÐÐͬÑù±È½Ï¿ì¡£µ«Êǵ±ÊµÊ©ÔÚ¿Í»§ÄDZßÔËÐеÄʱºòËٶȾͷdz£µÄÂý£¬Ê±¼ä³¬³öÁ˳ÌÐòµÄʱ¼äÏÞÖÆ¡£Ô¶³ÌÔÚ¿Í»§ÄÇ ......

SQL clr - MS-SQL Server / ·Ç¼¼Êõ°æ

ÏëÓÃSQL CLR×öÈçϵĴ洢¹ý³Ì,µ«ÊÇ·¢ÏÖ±¨´í: 
{ÓÉÓÚ´úÂëÒѾ­¹ýÓÅ»¯»òÕß±¾»ú¿ò¼ÜλÓÚµ÷ÓöÑÕ»Ö®ÉÏ£¬ÎÞ·¨¼ÆËã±í´ïʽµÄÖµ¡£} 
¶øÇÒÈç¹ûÊý¾Ý´Ócase 1ͨ¹ýʱ¾ÍÊÇÕýÈ·µÄ,´Ócase 2ͨ¹ýʱ´íÎó 
²¢ÇÒÔÚc ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ