sql²éѯ¸üеÄЧÂÊÎÊÌâ - MS-SQL Server / »ù´¡Àà
±íciku (ÕâÀïÓкº×Ö´ÊÎå°Ù¶àÍòÌõ£¬ºº×ÖÊý2-10²»µÈ)
ÏëʵÏÖ¸üÐÂ
SQL code:
update ciku set hz_pinyin = dbo.f_gettotalpy(hz_hanzi)
----º¯Êý £¬ÆäÖбízdÊǺº×ֿ⣬ÓÐÿ¸öµ¥¸öºº×ÖÓë ¶ÔÓ¦µÄÆ´Òô ²»¿¼ÂǶàÒô×Ö-----
SQL code:
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS ON
GO
ALTER function f_gettotalpy(@str varchar(100))
returns varchar(800)
as
begin
declare @re varchar(800)
declare @i int,@ilen int,@splitchr varchar(1)
select @splitchr='' --Á½¸öÆ´ÒôÖ®¼äµÄ·Ö¸ô·û(Ä¿µÄÊÇΪÁËͨÓÃÐÔ¿¼ÂÇ)
,@i=1,@ilen=len(@str)
select @re=pinyin from zd where hanzi=substring(@str,@i,1)
while @i<@ilen
begin
set @i=@i+1
select top 1 @re=@re+@splitchr+pinyin
from zd2 where hanzi=substring(@str,@i,1)
end
return(@re)
end
ÎÒÓà update ciku set hz_pinyin = dbo.f_gettotalpy(hz_hanzi) where hz_len=2 and hz_pinyin is null and hz_id<1000000 ¸üÐÂ100ÍòÌõÊý¾Ý20·ÖÖÓÁË»¹Ã»ºÃ¡£ Õ⻹ÊÇÖ»¸üÐÂ2¸öºº×Ö³¤¶ÈµÄ¡£
ÎÊÏÂÈçºÎÌá¸ßÏÂЧÂÊ¡£
¿´µÄ²»ÊǺÜÃ÷°×£¬°ï¶¥¡£
2000»¹ÊÇ2005£¿
SQL 2000ÖУ¬Èç¹ûSQL2005Óк÷½·¨Ò²¿ÉÒÔ»»³ÉSQL 2005
ÄãÕ
Ïà¹ØÎÊ´ð£º
¿ÉÄÜÒòΪ¹¤×÷µÄÔÒò ½Ó´¥Êý¾Ý¿âÕâ¿é±È½ÏÉÙ£¬Ö®Ç°¶¼ÊÇ×ö³ÌÐòÕâ¿é£¬Êý¾Ý¿âÕâ¿é¶¼ÓÐרÃŵÄÈËÀ´×ö ·Ö¹¤¶¼ºÜÃ÷ϸ ËùÒÔ¶ÔÊý¾Ý¿âÕâÒ»¿éÍêÈ«²»Á˽⡣ǰ¶Îʱ¼ä È¥ÃæÊÔÁ˼¸¼Ò¹«Ë¾ ¼¸ºõ¶¼ÊÇÔÚÊý¾Ý¿âÕâ¿é¹ÒµôµÄ Á¬¸ö¼òµ¥µÄSQ ......
ÕâÀïÏëÁ˽âÏ£¬¹ØÓÚSQL ServerÖзÖÒ³ºÍOracleÖзÖÒ³£»
ƽ³£Ð´Ó¦ÓóÌÐòµÄʱºò£¬±ÈÈçÓõÄÓïÑÔÊÇJava£¬ÓиöÁбíÒ³Ãæ£¬ÐèÒª¶ÔÊý¾Ý·ÖÒ³ÏÔʾ£»
ÕâÀïÒª·ÖÒ³ÄѵÀ²»ÐèÒª½èÖúJava£¬¶øÖ±½ÓsqlÄÜÖªµÀ·ÖÒ³Âð£¬ÆðÂëÒ²Òª´«¸öÒ³Âë½ ......
±íÊý¾Ý
COL1 COL2 COL2 COL4 COL5
----------------------------------------------------------------------------------------------
2010-05-05 00:00 ......
¸÷λºÃ£¬ÎÒ¸Õ°ÑÒ»¸öASPÍøÕ¾ÉèÖúÃÁË£¬Ò²ÄÜÕý³£·ÃÎÊ¡£µ«ÊÇÔÚÎÒ±¾»úÉϲ»ÄÜ´ò¿ªadmin\login.asp,ËùÒÔÎÞ·¨ÊµÏÖºǫ́¹ÜÀí¡££¨´íÎóÌáʾÎÞ·¨ÕÒµ½ÍøÒ³£¬´úÂë404£¬ÎҵIJÙ×÷ϵͳÊÇwin2000 server)
µ«ÊÇÆæ¹ÖµÄÊÇÔÚ¾ÖÓòÍøµÄÆäËû» ......