¾«ÃîsqlÓï¾ä
1. ˵Ã÷£º¸´ÖƱí(Ö»¸´Öƽṹ£¬Ô´±íÃû£ºa£¬Ð±íÃû£ºb)
SQL: select * into b from a where 1<>1;
2. ˵Ã÷£º¿½±´±í(¿½±´Êý¾Ý£¬Ô´±íÃû£ºa£¬Ä¿±ê±íÃû£ºb)
SQL: insert into b(a, b, c) select d, e, f from b;
3. ˵Ã÷£ºÏÔʾÎÄÕ¡¢Ìá½»È˺Í×îºó»Ø¸´Ê±¼ä
SQL: select a.title, a.username, b.adddate
from table a,(
select max(adddate) adddate
from table where table.title=a.title) b ¡¡
4. ˵Ã÷£ºÍâÁ¬½Ó²éѯ(±íÃû1£ºa£¬±íÃû2£ºb)
SQL: select a.a, a.b, a.c, b.c, b.d, b.f
from a LEFT OUT JOIN b ON a.a = b.c; ¡¡
5. ˵Ã÷£ºÈճ̰²ÅÅÌáǰÎå·ÖÖÓÌáÐÑ
SQL: select *
from Èճ̰²ÅÅ
where datediff(’’minute’’, f¿ªÊ¼Ê±¼ä, getdate())>5 ¡¡¡¡
¡¡¡¡
6. ˵Ã÷£ºÁ½ÕŹØÁª±í£¬É¾³ýÖ÷±íÖÐÒѾÔÚ¸±±íÖÐûÓеÄÐÅÏ¢
SQL: delete from info
where not exists(
select *
from infobz
where info.infid=infobz.infid );
7. ˵Ã÷£º——
SQL: SELECT A.NUM, A.NAME, B.UPD_DATE, B.PREV_UPD_DATE
from TABLE1,(SELECT X.NUM, X.UPD_DATE, Y.UPD_DATE PREV_UPD_DATE
from (SELECT NUM, UPD_DATE, INBOUND_QTY, STOCK_ONHAND
from TABLE2
WHERE TO_CHAR(UPD_DATE,’’YYYY/MM’’) =
TO_CHAR(SYSDATE, ’’YYYY/MM’’)) X,
(SELECT NUM, UPD_DATE, STOCK_ONHAND
from TABLE2
WHERE TO_CHAR(UPD_DATE,’’YYYY/MM’’) =
TO_CHAR(TO_DATE(TO_CHAR(SYSDATE, ’’YYYY/MM’’)
|| ’’/01’’,’’YYYY/MM/DD’’) - 1, ’’YYYY/MM’’) ) Y,
WHERE X.NUM = Y.NUM £¨+£©AND X.INBOUND_QTY
+ NVL(Y.STOCK_ONHAND,0) <> X.STOCK_ONHAND ) B
Ïà¹ØÎĵµ£º
1 £¬¶ÔÓÚÈÕÆÚ×Ö¶Î×Ö¶Î
access±íʾΪ£º#1981-28-12#
SQLSERVER2000±íʾΪ£º''1981-02-12''
2,SQLÓï¾äÇø±ð£¬select ,update ÔÚ¶Ôµ¥±í²Ù×÷ʱ¶¼²î²»¶à£¬
µ«¶à±í²Ù×÷ʱupdateÓï¾äµÄÇø±ðACCESSÓëSQLSERVERÖеÄUpdateÓï¾ä¶Ô±È:
SQLSERVERÖиüжà±íµÄUpdateÓï¾ä:
Update Tab1
SET a.Name = b.Name
from Tab1 a,Tab2 b
Whe ......
SQL Server 2005ʵÏÖ¸ºÔؾùºâ
ǰÑÔ
InternetµÄ¹æÄ£Ã¿Ò»°ÙÌì¾Í»áÔö³¤Ò»±¶£¬¿Í»§Ï£Íû»ñµÃ7Ìì×24СʱµÄ²»¼ä¶Ï¿ÉÓÃÐÔ¼°½Ï¿ìµÄϵͳ·´Ó¦Ê±¼ä£¬¶ø²»Ô¸ÂŴο´µ½Ä³¸öÕ¾µã“Server Too Busy”¼°Æµ·±µÄϵͳ¹ÊÕÏ¡£
Ëæ×ÅÒµÎñÁ¿µÄÌá¸ß,ÒÔ¼°·ÃÎÊÁ¿ºÍÊý¾ÝÁ÷Á¿µÄ¿ìËÙÔö³¤£¬ÍøÂç¸÷¸öºËÐIJ¿·ÖµÄ´¦ÀíÐÔÄܺͼÆËãÇ¿¶ÈÒ²ÏàÓ¦Ô ......
1.²éѯÊý¾Ý¿âÖеıíÊÇ·ñ´æÔÚ£º
sqlÓï¾ä£º
select count(1) from sysobjects where object_name(id)='±íÃû'
»ò£º
select count(*) from sysobjects where id = object_id(N'[±íÃû]') and OBJECTPROPERTY(id, N'IsUserTable') = 1
´æ´¢¹ý³Ì£º
IF Exists(Select 1 fro ......
1.×î»ù±¾µÄDBMS_OUTPUT.PUT_LINE()·½·¨¡£
¡¡¡¡Ëæ±ãÔÚʲôµØ·½£¬Ö»ÒªÊÇBEGINºÍENDÖ®¼ä£¬¾Í¿ÉÒÔʹÓÃDBMS_OUTPUT.PUT_LINE(output);È»¶øÕâ»áÓÐÒ»¸öÎÊÌ⣬¾ÍÊÇʹÓøú¯ÊýÒ»´Î×î¶àÖ»¿ÉÒÔÏÔʾ255¸ö×Ö·û£¬·ñÔò»º³åÇø»áÒç³ö¡£
¡¡¡¡´ËÍ⣬º¯ÊýDBMS_OUTPUT.ENABLE(20000)ÕâÖÖº¯Êý£¬½ö½öÊÇÉèÖÃÕû¸ö¹ý³ÌµÄÈ«²¿Êä³ö»º³åÇø´óС£¬¶ø·ÇDBM ......
--²éѯÊý¾Ý
SELECT *
from main_table;
--Ìí¼ÓÊôÐÔ
ALTER TABLE main_table
ADD AcctStop_Time SMALLDATETIME NULL;
--²åÈëÐÂÊý¾Ý
INSERT INTO main_table(Digital_ID, Letter_ID, User_Password, On_Line, IP, AcctStop_Time, FriendTable_UpdaeTime)
VALUES(10000000 + IDENT_CURRENT('main_table') + IDEN ......