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
ÄãÕ
Ïà¹ØÎÊ´ð£º
sqlµÄÈí¼þÔÚÄÄÀï¿ÉÒÔϰ¡£¡ÔÚÍøÉÏÕÒÁËÂù¶à¶¼Óò»Á˰¡
Ëæ±ã¸ãÒ»D°æ°É£¬
ѸÀ×µÚÒ»¸ö¾Í¿ÉÒÔÓÃ
2000,2005¶¼ÕâÑù
http://119.147.41.16/down?cid=0698C2D64D7D637D90A6D2482298E6717D4F15CD&t=2&fmt=-1 ......
ÓÐÕâÑùÒ»ÌõSQL
Select Get_Costtaxrate(col1), Get_Tcostvalue(col1) from a
ÆäÖÐGet_Costtaxrate¡¢Get_Tcostvalue¶¼ÊǺ¯Êý£¬ÕâÁ½¸öº¯ÊýÀïÃæ¶¼ÊDzéÕÒÒ»¸ö´ó±í£¬Get_Tcostvalue»¹ÐèÒªµ÷ÓÃGet_C ......
ÏÖÔÚÓÐÒ»¸ö²¿Ãűídept£¨²¿ÃÅÃû³Æ£¬²¿Ãźš£¡££©ÓÐÒ»¸öÈËÔ±±íemp£¨ÐÕÃû£¬ÈËÔ±±àºÅ£¬Ö°Î»£¬Ð½×Ê£¬²¿ÃÅ£©
emp±íÖеÄÄÚÈÝÊÇÕâÑùµÄ£º
a 1 ¹¤³Ìʦ 3000 Èí¼þ²¿
b 2 ÆÕͨԱ¹¤ 2000 Ó²¼þ²¿
c 3 ¹¤³Ìʦ 4000 Ó²¼þ²¿
d ......
ͨ¹ýNAME×Ö¶ÎÌõ¼þ²éѯһ¸öÊý¾Ý±í£¬¼ÙÉèÎÒÓÐ100¸öÐÕÃû£¬ÓÐÒÔÏÂÁ½¸ö·½·¨£¬
·½·¨1£º
°Ñ100¸öName ×é³ÉÒ»¸öSQLÓï¾ä£¬±ÈÈç Select * from tmp_table where Name='ÕÅÈý' or Name ='ÀîËÄ' Or ...Or Name='µÚÒ»°Ù¸öÐÕÃû'
......
select o_customer,o_price from orders having o_price >=avg(o_price)
select o_customer,o_price from orders where o_price >=(select avg(o_price) from orders)
ÎҸоõûÓÐÇø±ð°¡£¬ÔõôÔÚmysql»áÓÐ ......