Ò׽ؽØͼÈí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB
ÈÈÃűêÇ©£º c c# c++ asp asp.net linux php jsp java vb Python Ruby mysql sql access Sqlite sqlserver delphi javascript Oracle ajax wap mssql html css flash flex dreamweaver xml
 ×îÐÂÎÄÕ : mssql

ÇóÒ»¸ömssqlµÄsqlÓï¾ä - MS-SQL Server / »ù´¡Àà

ÅжϱíÖÐÊÇ·ñÓдóÓÚ10ÌõÒÔÉϵÄÊý¾Ý£¬
Èç¹û´æÔÚÔò°´×îºÃ¼ÈëµÄʱ¼ä£¬É¾³ýµô¶àÓàµÄÊý¾Ý¡£¡£
±£³ÖÊý¾Ý±íÖÐÖ»ÓÐ10Ìõ×îеÄÊý¾Ý¡£¡£
лл¡£
select ID,count(1) from TB group by ID having count(1)>10


SQL code:
;with t as
(
select rn=row_number()over(order by date desc),*
from tb
)
select * fr ......

Mssql2005 xml ²éѯ ʹÓà exist - .NET¼¼Êõ / C#

SQL code:

@uid int
@money float
If not exists(SELECT null from bc_users_table where bet_id=@uid and bet_hk_rationing.exist('/root/items[@straight_bet>'+@money+']') = 1)
--BEGIN
select '1111¡®
--RETURN
END
exist ²ÎÊý 1 ±ØÐëΪ ÖÐÎÄ×Ö·û£¿
ÄÄλÅóÓÑÓöµ ......

mssqlº¯Êý·­Òë - ÆäËûÊý¾Ý¿â¿ª·¢ / MySQL/Postgresql

¹òÇó½«ÒÔϺ¯Êý·­ÒëΪ mysql µÄÓï·¨
CREATE FUNCTION workdayadd( 
@date datetime, --»ù´¡ÈÕÆÚ 
@workday int --ÒªÔö¼ÓµÄ¹¤×÷ÈÕÊý 
)RETURNS datetime 
AS 
BEGIN 
DECLARE @bz int 
--Ôö¼ÓÕûÖܵÄÌìÊý 
SELECT @bz=CASE WHEN @workday<0 THEN -1 ELSE 1 END& ......

msSql ÐÞ¸Äʱ¼ä×ֶΠ- MS-SQL Server / »ù´¡Àà

±íA
SQL code:
autoID outDate type resultDate
1 2010-05-10 11£º12£º03 1 null
2 2010-05-10 15£º10£º03 0 null
3 2010-05-12 11£º12£º03 0 null
4 2010-05-14 11£º12£º03 ......

mssql null µÄÎÊÌâ - MS-SQL Server / ÒÉÄÑÎÊÌâ

select case null
when '' then '1' 
when null then '2' --ΪʲôûÓÐÔÚÕâ¸öλÖÃÅжϳöÀ´
else '3' 
end a 
select 1 a,2 b into #a
select isnull(b,0) b from #a where a=2
--bÁÐûÓÐÊý¾Ý Ó¦¸ÃÓÃʲôÀ´ÅжÏbÊÇ¿ÕµÄÄØ


--bÁÐûÓÐÊý¾Ý Ó¦¸ÃÓÃʲôÀ´ÅжÏbÊÇ¿ÕµÄÄØ
where b is null

NU ......

oracle ÈçºÎµ÷ÓÃmssql´æ´¢¹ý³Ì - Oracle / ¸ß¼¶¼¼Êõ

oracle ͨ¹ýBDlink Á¬½Óµ½Ò»Ì¨MS SQL,²éѯ¶¼¿ÉÒÔ,µ«ÊDz»ÖªµÀÈçºÎÔÚoracleͨ¹ýDBLinkµ÷ÓÃMS SQLµÄ´æ´¢¹ý³Ì,Çó½â~лл~
ÒýÓÃ
oracle ͨ¹ýBDlink Á¬½Óµ½Ò»Ì¨MS SQL,²éѯ¶¼¿ÉÒÔ,µ«ÊDz»ÖªµÀÈçºÎÔÚoracleͨ¹ýDBLinkµ÷ÓÃMS SQLµÄ´æ´¢¹ý³Ì,Çó½â~лл~
²éѯ¿ÉÒԵĻ° Äǵ÷Óô洢¹ý³ÌÒ²²»ÊÇÎÊÌâ ºÍÄãµÄ²éѯÊÇÒ»ÑùµÄ

²éѯÓï¾äÊÇ ......
×ܼǼÊý:200; ×ÜÒ³Êý:34; ÿҳ6 Ìõ; Ê×Ò³ ÉÏÒ»Ò³ [1] [2] 3 [4] [5] [6] [7] [8] [9] [10]  ÏÂÒ»Ò³ βҳ
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ