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

SqlserverµÃµ½ºº×ÖÆ´ÒôÊ××Öĸ´æ´¢¹ý³Ì

SqlserverµÃµ½ºº×ÖÆ´ÒôÊ××Öĸ´æ´¢¹ý³Ì:
create function [dbo].[fun_getPY]
(
@str nvarchar(4000)
)
returns nvarchar(4000)
as
begin
declare @word nchar(1),@PY nvarchar(4000)
set @PY=''
while len(@str)>0
begin
   set @word=left(@str,1)
   --Èç¹û·Çºº×Ö×Ö·û£¬·µ»ØÔ­×Ö·û
   set @PY=@PY+(case when unicode(@word) between 19968 and 19968+20901
       ¡¡then (select top 1 PY from (
              ¡¡select 'A' as PY,N'æñ' as word
               union all select 'B',N'²¾'
               union all select 'C',N'´í'
               union all select 'D',N'鵽'
               union all select 'E',N'樲'
               union all select 'F',N'öû'
               union all select 'G',N'腂'
               union all select 'H',N'夻'
               union all select 'J',N'攈'
               union all select 'K',N'穒'
               union all select 'L',N'鱳'
               union all select 'M',N'旀'
               union all select 'N',N'桛'
    &nb


Ïà¹ØÎĵµ£º

´¿JSP·ÖÒ³´úÂëÖ®sqlserver2005/2008

ÉÏһƪ·ÖÒ³ÎÄÕ£¬ÊÇÓÃÓÚmysql£¬ÉÔ΢ÐÞ¸ÄÏ£¬ÓÃÓÚSqlserver2005/2008£¬Ã»ÓÐÒì³£´¦Àí¡£Ã»Óп¼ÂÇÐÔÄܵȡ£
ÏÖ½«´úÂëÌù³ö£¬ÒÔ¹©³õѧÕ߲ο¼£º
×¢£ºÑûÔÂʹÓû·¾³Eclipse 3.4.2+Tomcat 6.18+Sqlserver2005 sp3µ÷ÊԳɹ¦¡£
Ò³ÃæpagelistDemo.jspÄÚÈÝ£º
Code
<%@ page language="java" contentType="text/html; ......

SqlServerÊý¾Ý¿â×Öµä£¨×ªÔØ£©


ÒýÓÃ×Ôhttp://blog.163.com/xing_aixin/blog/static/3723550520088189201623/
ÍøÉÏÓкܶàSQL ServerÊý¾Ý¿â×ÖµäµÄSQLÓï¾ä£¬ÆßÁã°ËÂ䣬ÎÒÔÚ¹¤×÷ÕûÀíÁËÒ»ÏÂ˼·£¬×ܽáSQL´úÂëÈçÏ¡£Êý¾Ý¿â×Öµä°üÀ¨±í½á¹¹(·Ö2KºÍ2005)¡¢Ë÷ÒýºÍÖ÷¼ü. Íâ¼ü.Ô¼Êø.ÊÓͼ.º¯Êý.´æ´¢¹ý³Ì.´¥·¢Æ÷¡£¿ÉÒÔÔÚÆóÒµ¹ÜÀíÆ÷¡¢²éѯ·ÖÎöÆ÷Öмòµ¥Ö´ÐУ¬Ö±½ÓÁ˵±µ ......

SQLServerÊý¾Ý¿âά¶È±íºÍÊÂʵ±í¸ÅÊö

¡¡¡¡ÊÂʵ±í
¡¡¡¡Ã¿¸öÊý¾Ý²Ö¿â¶¼°üº¬Ò»¸ö»òÕß¶à¸öÊÂʵÊý¾Ý±í¡£ÊÂʵÊý¾Ý±í¿ÉÄܰüº¬ÒµÎñÏúÊÛÊý¾Ý£¬ÈçÏÖ½ðµÇ¼ÇÊÂÎñ
¡¡¡¡Ëù²úÉúµÄÊý¾Ý£¬ÊÂʵÊý¾Ý±íͨ³£°üº¬´óÁ¿µÄÐС£ÊÂʵÊý¾Ý±íµÄÖ÷ÒªÌØµãÊǰüº¬Êý×ÖÊý¾Ý(ÊÂʵ)£¬²¢ÇÒÕâЩÊý×ÖÐÅÏ¢¿ÉÒÔ»ã×Ü£¬ÒÔÌṩÓйص¥Î»×÷ΪÀúÊ·µÄÊý¾Ý£¬Ã¿¸öÊÂʵÊý¾Ý±í°üº¬Ò»¸öÓɶà¸ö²¿·Ö×é³ÉµÄË÷Òý£¬¸ÃË÷Òý ......

sqlServerÖеÄ×ÔÔö×Ö¶Î


 
SQLÓï¾äÈçÏÂ:
CREATE TABLE [dbo].[test_table] (
    [ID] [int] IDENTITY (1, 1) NOT NULL ,
    [NAME] [varchar] (80)
)
Éè¼ÆÊÓͼÏÂ,ÔÚÌí¼ÓÒ»¸öINTÐ͵Ä×Ö¶ÎÊÇ,Ñ¡ÖÐÏ·½µÄ"±êʶ"Ϊ"ÊÇ",ÏÂÃæÓÐ"±êʶÖÖ×Ó"ºÍ"±êʶ×ÔÔöÁ¿",¿ÉÒÔ×Ô¼ºÉèÖÃ,ĬÈ϶¼Îª1
µ«ÊDz»ÖªµÀΪʲô,ʹÓÃÈÎÎ ......

SQLSERVERÊý¾Ý¿â¿ª·¢µÄ¶þʮһÌõ¾ü¹æ

SQL SERVERÊý¾Ý¿â¿ª·¢µÄ¶þʮһÌõ¾ü¹æ
Èç¹ûÄãÕýÔÚ¸ºÔðÒ»»ùÓÚSQL SERVER µÄÏîÄ¿£¬»òÕ߸ոսӴ¥SQL SERVER£¬Äã¿ÉÄܽ«ÃæÁÙһЩÊý¾Ý¿âÐÔÄܵÄÎÊÌâ¡£ÕâÆªÎÄÕ»áÌṩһЩÓÐÓõľ­Ñé-----¹ØÓÚÈçºÎÐγɺõÄÉè¼Æ¡£
Ò»¡¢Á˽âÄãÓõŤ¾ß
²»ÒªÇáÊÓÕâÒ»µã£¬ÕâÊDZ¾ÎÄ×î¹Ø¼üµÄÒ»Ìõ¡£Ò²ÐíÄãÒ²¿´µ½ÓкܶàµÄSQL SERVER³ÌÐòԱûÓÐÕÆÎÕÈ«²¿µÄT- ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ