sql ºº×ÖתÊ××ÖĸƴÒô
	
    
    
	create function 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'桛' 
union all select 'O',N'漚' 
union all select 'P',N'ÆØ' 
union all select 'Q',N'囕' 
union all select 'R',N'鶸' 
union all select 'S',N'蜶' 
union all select 'T',N'籜' 
union all select 'W',N'鶩' 
union all select 'X',N'鑂' 
union all select 'Y',N'韻' 
union all select 'Z',N'咗' 
) T  
where word>=@word collate Chinese_PRC_CS_AS_KS_WS  
order by PY ASC) else @word end) 
set @str=right(@str,len(@str)-1) 
end 
return @PY 
end 
--º¯Êýµ÷ÓÃʵÀý£º 
--select dbo.fun_getPY('ÖлªÈËÃñ¹²ºÍ¹ú') 
----------------------------------------------------------------- 
--¿ÉÖ§³Ö´ó×Ö·û¼¯20000¸öºº×Ö!   
create   function   f_ch2py(@chn   nchar(1))   
  returns   char(1)   
  as   
  begin   
  declare   @n   int   
  declare   @c   char(1)   
  set   @n   =   63   
    
  select   @n   =   @n   +1,   
                @c   =   case   chn   when   @chn   then   char(@n)   else   @c   end   
  from(   
    select   top   27   *   from   (   
            select   chn   =     
  'ß¹'   union   all   select   
  '°Ë'   union   all   select   
  'àê'   union   all   select   
  '咑'   union   all   select   
  '妸'   unio
    
     
	
	
    
    
	Ïà¹ØÎĵµ£º
        
    
    Ô¶³ÌÁ¬½Ósql server 2000·þÎñÆ÷µÄ½â¾ö·½°¸ 
                                        ----ת×Ô£º·ÉºüСÎÝ
ÓÉÓ ......
	
    
        
    
     .Frm644 { display:none; } 
¡¡¡¡1¡£ÒѾ¼ìÑéµÄÓï¾äºÍÒÑÔÚ¹²Ïí³ØÖеÄÓï¾äÖ®¼äÒªÍêȫһÑù
¡¡¡¡2¡£±äÁ¿Ãû³Æ¾¡Á¿Ò»ÖÂ
¡¡¡¡3¡£ºÏÀíʹÓÃÍâÁª½Ó
¡¡¡¡4¡£ÉÙ
Óöà²ãǶÌ×
¡¡¡¡5¡£¶àÓò¢·¢
¡¡¡¡
¡¡¡¡Óï¾äµÄÓÅ»¯²½ÖèÒ»°ãÓУº
¡¡¡¡1¡£µ÷ÕûsgaÇø£¬Ê¹µÃsgaÇøµÄÊÇÓÃ×îÓÅ¡£
¡¡
¡¡2¡£sqlÓï¾ä±¾ÉíµÄÓÅ»¯£¬¹¤¾ßÓÐexplain,sql trace ......
	
    
        
    
    Ó¦Ò»¸öÅóÓѵÄÒªÇó£¬ÌùÉÏÊղصÄSQL³£Ó÷ÖÒ³µÄ°ì·¨¡«¡« 
±íÖÐÖ÷¼ü±ØÐëΪ±êʶÁУ¬[ID] int IDENTITY (1,1) 
1.·ÖÒ³·½°¸Ò»£º(ÀûÓÃNot InºÍSELECT TOP·ÖÒ³) 
Óï¾äÐÎʽ£º  
SELECT TOP Ò³¼Ç¼ÊýÁ¿ * 
from ±íÃû 
WHERE (ID NOT IN 
  (SELECT TOP (ÿҳÐÐÊý*(Ò³Êý-1)) ID 
  from ±íÃû 
  ORDER BY  ......
	
    
        
    
    I'm continually trying to track down what service packs are installed on various SQL Servers I support. I can never find the right support page on Microsoft's site. So here's an article with all the SQL Server version information I can track down. If you know of any older versions or can help me fil ......
	
    
        
    
    UpSert¹¦ÄÜ£º
MERGE <hint> INTO <table_name>
USING <table_view_or_query>
ON (<condition>)
WHEN MATCHED THEN <update_clause>
WHEN NOT MATCHED THEN <insert_clause>; 
MultiTable Inserts¹¦ÄÜ£º
Multitable inserts allow a single INSERT INTO .. SELECT statement to  ......