sql inÓÅ»¯
¿Í»§·´Ó³³ÌÐòºÜÂý£¬¿ªÊ¼ÒÔΪÊý¾ÝÁ¿´ó£¬ÔÚ±íÖвéѯʹÓõÄ×Ö¶ÎÉÏ£¬Ìí¼ÓÁËË÷Òý£¬Ã»ÓÐÃ÷ÏÔµÄЧ¹û£¬¼ì²éʱ·¢ÏÖÒÔÇ°µÄͬÊÂÔÚsql serverÖÐдµÄº¯ÊýÖÐʹÓÃÁËin£¬¶øÔÚinµÄ½á¹û¼¯ÖлáÓÐ2500Ìõ¼Ç¼×óÓÒ£¬Ö´ÐÐʱ¼äÐèÒª13Ãë¡£ÕÒµ½ÎÊÌâ¸ùÔ´£¬
Ð޸ķ½·¨£º °ÑinºóÃæµÄ×Ó²éѯ×÷Ϊһ¸ö±íºÍÖ÷±í¹ØÁª£¬Ìí¼ÓÏÞÖÆÌõ¼þ¡£
ÔÀ´Ð´·¨£º select * from a where a.id in (select bid from b)
Ð޸ĺóд·¨£º select a.* from a, b where a.id=b.bid
Ð޸ĺóÖ´ÐÐʱ¼äΪ1Ãë¡£
ËùÒÔ£¬ÔÚʹÓÃinµÄʱºò£¬Ò»¶¨Òª¿¼ÂǺóÃæµÄ¼¯ºÏµ½µ×Óжà´ó¡£Èç¹ûºÜ´ó£¬¾¡Á¿²»ÒªÊ¹ÓÃin¡£
Ïà¹ØÎĵµ£º
Ç°Ìá,MS SQLµÄͨÅä·ûº¬Ò壺
ÐòºÅ
ͨÅä·û
º¬Òå
ʾÀý
1
%
°üº¬Áã¸ö»ò¶à¸ö×Ö·ûµÄÈÎÒâ×Ö·û´®¡£
WHERE title LIKE '%computer%' ½«²éÕÒÔÚÊéÃûÖÐÈÎÒâλÖðüº¬µ¥´Ê"computer" µÄËùÓÐÊéÃû¡£
2
_
Èκε¥¸ö×Ö·û¡£
WHERE au_fname LIKE '_ean' ½«²éÕÒÒÔ ean ½áβµÄËùÓÐ 4 ¸ö×ÖĸµÄÃû×Ö£¨Dean¡¢Sean µÈ£©¡£
3
[ ] ......
ÏÂÁÐÓï¾ä²¿·ÖÊÇMssqlÓï¾ä£¬²»¿ÉÒÔÔÚaccessÖÐʹÓá£
¡¡¡¡SQL·ÖÀࣺ
¡¡¡¡DDL—Êý¾Ý¶¨ÒåÓïÑÔ
(CREATE£¬ALTER£¬DROP£¬DECLARE)
¡¡¡¡DML—Êý¾Ý²Ù×ÝÓïÑÔ
(SELECT£¬DELETE£¬UPDATE£¬INSERT)
¡¡¡¡DCL—Êý¾Ý¿ØÖÆÓïÑÔ
(GRANT£¬REVOKE£¬COMMIT£¬ROLLBACK)
¡¡¡¡Ê×ÏÈ,¼òÒª½éÉÜ»ù´¡Óï¾ä£º
¡¡¡¡1¡¢ËµÃ÷£º´´½¨Êý ......
use master
go
--Çл»masterÊý¾Ý¿â
if exists(select 1 from sysdatabases where name = N'test')
--×¢Òâ¸ÃͬÃûÊý¾Ý¿âÊÇ·ñ»¹ÒªÓõ½
begin
drop database test
end
go
create database test
on
primary
( name = 'testprimary', --Ö÷Êý¾ÝÎļþÂß¼Ãû
filename = 'D:\testprimary.mdf',--Ö÷Êý¾ÝÎļþ´æ·Å·¾¶
......
1. µ±Ç°ÏµÍ³ÈÕÆÚ¡¢Ê±¼ä
select getdate()
2. dateadd ÔÚÏòÖ¸¶¨ÈÕÆÚ¼ÓÉÏÒ»¶Îʱ¼äµÄ»ù´¡ÉÏ£¬·µ»ØÐ嵀 datetime Öµ
ÀýÈ磺ÏòÈÕÆÚ¼ÓÉÏ2Ìì
select dateadd(day,2,'2004-10-15') --·µ»Ø£º2004-10-17 00:00:00.000
3. datediff ·µ»Ø¿çÁ½¸öÖ¸¶¨ÈÕÆÚµÄÈÕÆÚºÍʱ¼ä±ß½çÊý¡£
select datediff(day,'2004-09-01','2004-09-18') --· ......