sql serverÎÞ·¨Á¬½Ó issue
http://blog.csdn.net/java2000_net/archive/2008/04/05/2252640.aspx
http://sqlserver.chinahtml.com/2006/SQL-mssql11432786154012.shtml
http://www.cnblogs.com/garnai/archive/2007/09/19/898221.html
http://tech.ccidnet.com/art/1099/20050223/214511_1.html
http://www.wangchao.net.cn/bbsdetail_43009.html
Ïà¹ØÎĵµ£º
/***************************************************
×÷Õߣºherowang(ÈÃÄãÍû¼ûÓ°×ÓµÄǽ£©
ÈÕÆÚ£º2010.1.1
×¢£º ×ªÔØÇë±£Áô´ËÐÅÏ¢
& ......
PATINDEX
·µ»ØÖ¸¶¨±í´ïʽÖÐijģʽµÚÒ»´Î³öÏֵįðʼλÖã»Èç¹ûÔÚÈ«²¿ÓÐЧµÄÎı¾ºÍ×Ö·ûÊý¾ÝÀàÐÍÖÐûÓÐÕÒµ½¸Ãģʽ£¬Ôò·µ»ØÁã¡£
Óï·¨
PATINDEX ( '%pattern%' , expression )
²ÎÊý
pattern
Ò»¸ö×Ö·û´®¡£¿ÉÒÔʹÓÃͨÅä·û£¬µ« pattern ֮ǰºÍÖ®ºó±ØÐëÓÐ % ×Ö·û£¨ËÑË÷µÚÒ»¸öºÍ×îºóÒ»¸ö×Ö·ûʱ³ýÍ⣩¡£pattern ÊǶÌ×Ö·ûÊý ......
Select CONVERT(varchar(100), GETDATE(), 0) as 05 16 2006 10:57AM
Select CONVERT(varchar(100), GETDATE(), 1) as 05/16/06
Select CONVERT(varchar(100), GETDATE(), 2) as 06.05.16
Select CONVERT(varchar(100), GETDATE(), 3) as 16/05/06
Select CONVERT(varchar(100), GETDATE(), 4) as 16.05.06
Select CON ......
ΪÁË´¦Àí SQL Óï¾ä£¬ORACLE ±ØÐë·ÖÅäһƬ½ÐÉÏÏÂÎÄ( context area )µÄÇøÓòÀ´´¦ÀíËù±ØÐèµÄÐÅÏ¢£¬ÆäÖаüÀ¨Òª´¦ÀíµÄÐеÄÊýÄ¿£¬Ò»¸öÖ¸ÏòÓï¾ä±»·ÖÎöÒÔºóµÄ±íʾÐÎʽµÄÖ¸ÕëÒÔ¼°²éѯµÄ»î¶¯¼¯(active set)¡£
ÓαêÊÇÒ»¸öÖ¸ÏòÉÏÏÂÎĵľä±ú( handle)»òÖ¸Õ롣ͨ¹ýÓα꣬PL/SQL¿ÉÒÔ¿ØÖÆÉÏÏÂÎÄÇøºÍ´¦ÀíÓï¾äʱÉÏÏÂÎÄÇø»á·¢ÉúЩʲôÊÂÇ ......