ÔÚSQLÓï¾äÖнØÈ¡×Ö·û´®º¯ÊýµÄÓ¦ÓÃ
ÎÊÌâÒ»
ÓÐÕâÑùµÄÒ»¸öÎÊÌ⣬Êý¾Ý¿âÖÐÓÐÁ½¸ö±í£¬·Ö±ðÊÇGuest,Hotel£¬¼´ÂÿÍÐÅÏ¢±íºÍÂùÝÐÅÏ¢±í£¬Guest±íÖÐÓÐÒ»¸öÂÿͱàÂëµÄ×ֶΣ¬Õâ¸ö×ֶεÄÓÐ20룬ËüµÄÇ°10λ´ú±íÕâ¸öÂÿÍËùסµÄÂùݣ¬ÏÖÔÚµÄÎÊÌâÊÇÒª¸ù¾ÝGuest±íÖеÄÂÿͱàÂë×Ö¶ÎÐÅÏ¢²éµ½ËûËùסµÄÂùݵÄÃû³ÆºÍÂùݵØÖ·£¡
ÎÊÌâ½â¾ö:
SQL SERVERµÄSQLÓï¾ä£ºselect Guest.ÂÿͱàÂë,Guest.ÂÿÍÐÕÃû,Hotel.ÂùÝÃû³Æ,Hotel.ÂùݵØÖ· from Guest,Hotel where Hotel.ÂùݱàÂë=SubString(Guest.ÂÿͱàÂë,1,10)
OracleµÄSQLÓï¾ä£ºselect Guest.ÂÿͱàÂë,Guest.ÂÿÍÐÕÃû,Hotel.ÂùÝÃû³Æ,Hotel.ÂùݵØÖ· from Guest,Hotel where Hotel.ÂùݱàÂë=SubStr(Guest.ÂÿͱàÂë,1,10)
ÎÊÌâ¶þ
A.½ØÈ¡´Ó×Ö·û´®×ó±ß¿ªÊ¼N¸ö×Ö·û
Declare @S1 varchar(100)
Select @S1='http://www.xrss.cn'
Select Left(@S1,4)
------------------------------------
ÏÔʾ½á¹û: http
B.½ØÈ¡´Ó×Ö·û´®Óұ߿ªÊ¼N¸ö×Ö·û(ÀýÈçÈ¡×Ö·ûwww.163.com)
Declare @S1 varchar(100)
Select @S1='http://www.xrss.cn'
Select right(@S1,11)
------------------------------------
ÏÔʾ½á¹û: www.163.com £¿£¿£¿£¿
C.½ØÈ¡×Ö·û´®ÖÐÈÎÒâλÖü°³¤¶È(ÀýÈçÈ¡×Ö·ûwww)
Declare @S1 varchar(100)
Select @S1='http://www.xrss.cn'
Select SUBSTRING(@S1,8,3)
------------------------------------
ÏÔʾ½á¹û: www.163.com
ÒÔÉÏÀý×Ó½ÔÊÇÒÑÖª½ØȡλÖü°³¤¶È,ÏÂÃæ½éÉÜδ֪λÖõÄÀý×Ó
2.½Øȡδ֪λÖõĺ¯Êý
&n
Ïà¹ØÎĵµ£º
Ò»¡¢±³¾°½éÉÜ
¡¡¡¡
¡¡¡¡½á¹¹»¯²éѯÓïÑÔ(Structured Query Language£¬¼ò³ÆSQL)ÊÇÓÃÀ´·ÃÎʹØϵÐÍÊý¾Ý¿âÒ»ÖÖͨÓÃÓïÑÔ£¬ÊôÓÚµÚËÄ´úÓïÑÔ£¨4GL£©£¬ÆäÖ´ÐÐÌصãÊǷǹý³Ì»¯£¬¼´²»ÓÃÖ¸Ã÷Ö´ÐеľßÌå·½·¨ºÍ;¾¶£¬¶øÊǼòµ¥µØµ÷ÓÃÏàÓ¦Óï¾äÀ´Ö±½ÓÈ¡µÃ½á¹û¼´¿É¡£ÏÔÈ»£¬ÕâÖÖ²»¹Ø×¢ÈκÎʵÏÖϸ½ÚµÄÓïÑÔ¶ÔÓÚ¿ª·¢ÕßÀ´ËµÓÐ׿«´óµÄ±ãÀû¡£È»¶ø£¬Ó ......
ÔÚWhere×Ó¾äÖУ¬¿ÉÒÔ¶Ôdatetime¡¢char¡¢varchar×Ö¶ÎÀàÐ͵ÄÁÐÓÃLike×Ó¾äÅäºÏͨÅä·ûÑ¡È¡ÄÇЩ“ºÜÏñ...”µÄÊý¾Ý¼Ç¼£¬ÒÔÏÂÊÇ¿ÉʹÓõÄͨÅä·û£º
% Áã»òÕ߶à¸ö×Ö·û
_ µ¥Ò»ÈκÎ×Ö·û£¨Ï»®Ïߣ©
\ ÌØÊâ×Ö·û
[] ÔÚijһ·¶Î§ÄÚµÄ×Ö·û£¬Èç ......
Ò»²½Ò»²½Ñ§Linq to sql£¨Ò»£©£ºÔ¤±¸ÖªÊ¶
Ò»²½Ò»²½Ñ§Linq to sql£¨¶þ£©£ºDataContextÓëʵÌå
Ò»²½Ò»²½Ñ§Linq to sql£¨Èý£©£ºÔöɾ¸Ä
Ò»²½Ò»²½Ñ§Linq to sql£¨ËÄ£©£º²éѯ¾ä·¨
Ò»²½Ò»²½Ñ§Linq to sql£¨Î壩£º´æ´¢¹ý³Ì
Ò»²½Ò»²½Ñ§Linq to sql£¨Áù£©£ºÌ½¾¿ÌØÐÔ
Ò»²½Ò»²½Ñ§Linq to sql£¨Æߣ©£º²¢·¢ÓëÊÂÎñ ......