SQL ServerÈ«ÎÄË÷ÒýµÄ¸öÈË×ܽá(ÉÏ) ¹ØÓÚÖÐÎÄ·Ö´Ê
SQL ServerÈ«ÎÄË÷ÒýµÄ¸öÈË×ܽá(ÉÏ) -¹ØÓÚÖÐÎÄ·Ö´Ê
(2005-11-14 04:29:44)
תÔØ
·ÖÀࣺÉî¶ÈÑо¿
´ó¼Ò¶¼ÖªµÀLIKE²éѯºÜÂý£¬È«ÎÄË÷Òý¾ÍÊÇÊÂÏÈ×öºÃÏà¹ØµÄË÷Òý£¬±íʾÄĸöÖ÷Ìâ´Ê¿ÉÒÔÔÚÄÄЩ¼Ç¼ÀïÕÒµ½£¬ÉõÖÁÊÂÏȼÆËãºÃRANK£¬¼ìË÷ʱ¿ÉÒÔ°ÑÏà¹Ø¶È¸ßµÄÏÈÁгöÀ´£¬Õâ¿ÉÒÔ´ó´óÌá¸ß¼ìË÷µÄËٶȡ£
´ò¸ö±È·½£¬ÄãÓкܶàµÄС³éÌ룬ÿ¸ö³éÌëÀïÃæ·ÅһЩÔÓÎ¼ÙÈçÄãÒªÕÒ¶«Î÷£¬×îÔʼµÄ·½·¨¾ÍÊÇÒ»¸ö¸ö³éÌë·£¬Õâ¾ÍÊÇûÓÐË÷ÒýµÄÇé¿ö¡£
¼ÙÈç´ÏÃ÷Ò»µã£¬¸ø³éÌë±àºÅ(Ψһ¼ü)£¬°ÑÄĸöºÅÂëµÄ³éÌëÓÐʲô¶«Î÷¼Ç¼ÔÚÖ½ÉÏ£¬ÕÒ¶«Î÷ÏÈ¿´¿´ÕâÕÅÖ½£¬Õâ¾ÍÊÇÆÕͨË÷Òý£¬¼ÙÈçÄãÒªÖªµÀÄĸö³éÌëÓÐʲô£¬Äã¿ÉÒÔÔÚÖ½ÉÏѸËÙÕÒµ½³éÌëºÅÂë(´ó¼ÒÖªµÀÕâÊÇʹÓòéÕÒÊ÷)£¬È»ºóµÃµ½Ïà¹ØµÄÐÅÏ¢£¬ÕâÖÖÇé¿öÆÕͨË÷ÒýÊǺܿìµÄ£»µ«ÊÇÒªÕÒµ½Ò»¸öÌض¨µÄ¶«Î÷ÄÄЩ³éÌëÓУ¬Äã¾ÍÒª°ÑÕûÕÅÖ½±éÀúÒ»´Î£¬Õâ¾ÍÊÇLIKE²éѯ£¬¼ÙÈçÄãÒªÕÒÄÄЩ³éÌëͬʱÓÐ2ÖÖÉõÖÁ¸ü¶àÖÖÎïÆ·£¬LIKE¾Í¸ü¼Ó·±ËöÁË¡£¼ÙÈçÒ»¸ö±íÓÐÉÏǧÍòµÄ¼Í¼£¬´ó¼Ò¿ÉÒÔÏëÏó²éѯµÄ´ú¼Û¡£
¿ÉÒÔ»»Ò»¸ö˼·£¬ÁíÍâÕÒÕÅÖ½£¬¼Ç¼һÑù¶«Î÷´æÔÚÓÚÄÄЩ³éÌ룺
¼Ð×Ó:1,3,4,5,6,9,12...
Ç®±Ò:2,3,4,7,12...
Ò©Íè:1,3,5,6...
ÕâÑùÕÒµ½Ä³Ñù¶«Î÷»òÕßij¼¸Ñù¶«Î÷¶¼ºÜÈÝÒס£
È«ÎÄË÷ÒýºÍÆÕͨµÄSQLË÷ÒýÓкܶàµÄÇø±ð£º
ÆÕͨ SQL Ë÷Òý
È«ÎÄË÷Òý
´æ´¢Ê±Êܶ¨ÒåËüÃÇËùÔÚµÄÊý¾Ý¿âµÄ¿ØÖÆ¡£
´æ´¢ÔÚÎļþϵͳÖУ¬µ«Í¨¹ýÊý¾Ý¿â¹ÜÀí¡£
ÿ¸ö±íÔÊÐíÓÐÈô¸É¸öÆÕͨË÷Òý¡£
ÿ¸ö±íÖ»ÔÊÐíÓÐÒ»¸öÈ«ÎÄË÷Òý¡£
µ±¶Ô×÷ΪÆä»ù´¡µÄÊý¾Ý½øÐвåÈë¡¢¸üлòɾ³ýʱ£¬ËüÃÇ×Ô¶¯¸üС£
½«Êý¾ÝÌí¼Óµ½È«ÎÄË÷Òý³ÆΪÌî³ä£¬È«ÎÄË÷Òý¿Éͨ¹ýµ÷¶È»òÌض¨ÇëÇóÀ´ÇëÇó£¬Ò²¿ÉÒÔÔÚÌí¼ÓÐÂÊý¾Ýʱ×Ô¶¯·¢Éú¡£
²»·Ö×é¡£
ÔÚͬһ¸öÊý¾Ý¿âÄÚ·Ö×éΪһ¸ö»ò¶à¸öÈ«ÎÄĿ¼¡£
ʹÓà SQL Server ÆóÒµ¹ÜÀíÆ÷¡¢Ïòµ¼»ò Transact-SQL Óï¾ä´´½¨ºÍ³ýÈ¥¡£
ʹÓà SQL Server ÆóÒµ¹ÜÀíÆ÷¡¢Ïòµ¼»ò´æ´¢¹ý³Ì´´½¨¡¢¹ÜÀíºÍ³ýÈ¥¡£
ʹÓÃÈ«ÎÄË÷ÒýµÄ»°£¬¿ÉÒÔ¿´¿´ÏÂÃæµÄÌû×Ó(¸Ðл´óÁ¦ºÍlihonggen0)£º
???? ÈçºÎÔÚsqlserverÖн¨Á¢È«ÎÄË÷Òý£º
???? http://www.csdn.net/develop/Read_Article.asp?Id=17137
???
???? ÈçºÎʹÓÃimage×ֶΣº
???? http://expert.csdn.net/Expert/topic/1594/1594455.xml
·¢ÏÖ´ó¼ÒÓÐÒ»¸ö³£ÎʵÄÎÊÌ⣬¾ÍÊǹØÓÚÒÔϵÄÐÅÏ¢µÄ:
²éѯ×Ó¾äÖ»°üº¬±»ºöÂԵĴÊ
ÕâÊÇÒòΪʹÓÃһЩºÜ¼òµ¥µÄ´Ê£¬±ÈÈç'ÊÇ'£¬½øÐвéѯµÄÔµ¹Ê¡£
Ìá³öµÄ½â¾ö°ì·¨²»ÍâºõÊÇ°ÑC:\Program Files\Microsoft SQL Server\MSSQL\FTDATA\SQLServe
Ïà¹ØÎĵµ£º
1¡¢ÏÂÔرر¸Èí¼þ
(1) JDK (Java Development Kit)
SUN¹Ù·½µÄÏÂÔصØÖ·ÊÇhttp://java.sun.com/javase/downloads/index.jsp
(2) JDBC
(3) Eclipse
(4) Microsoft SQL Server 2005 Express£¨µ±È»£¬ÓзÇExpressÒ²OK°¡£©
(5) SQL Server Management Studio
2¡¢°²×°Óë»·¾³ÅäÖÃ
(1) JDK
Ê×ÏÈÔÚWindows»·¾³Ï£¬ÏÂÔغó° ......
declare @str varchar(50)
declare @i int
set @str = ''
set @i=0
while @i<50
begin
set @str = ......
ÏÂÁÐÓï¾ä²¿·ÖÊÇMssqlÓï¾ä£¬²»¿ÉÒÔÔÚaccessÖÐʹÓá£
SQL·ÖÀࣺ
DDL—Êý¾Ý¶¨ÒåÓïÑÔ(Create£¬Alter£¬Drop£¬DECLARE)
DML—Êý¾Ý²Ù×ÝÓïÑÔ(Select£¬Delete£¬Update£¬Insert)
DCL—Êý¾Ý¿ØÖÆÓïÑÔ(GRANT£¬REVOKE£¬COMMIT£¬ROLLBACK)
Ê×ÏÈ,¼òÒª½éÉÜ»ù´¡Óï¾ä£º
1¡¢ËµÃ÷£º´´½¨Êý¾Ý¿â
Create&nb ......
¾¯±¨¹ÜÀí
×÷ÒµÖ´ÐÐʱ£¬SQL Server´íÎóÏûÏ¢µÄÐÅÏ¢´æ·ÅÔÚWindowsÊÂÎñÈÕÖ¾ÖС£SQL Server´úÀí¶ÁÈ¡Õâ¸öÈÕÖ¾£¬²¢±È½Ï´æ´¢µÄÏûÏ¢ÓëΪϵͳ¶¨ÒåµÄ¾¯±¨£¬Èç¹ûÆ¥Å䣬SQL Server´úÀí¼¤»î¸Ã¾¯±¨£¬ËùÒÔ£¬¾¯±¨¿ÉÒÔÓÃÓÚÏìӦDZÔÚµÄÎÊÌâ(ÈçÌîÂúÊÂÎñÈÕÖ¾)¡£µ±¾¯±¨±»´¥·¢Ê±£¬Í¨¹ýµç×ÓÓʼþ»òÕßÑ°ºô֪ͨ²Ù×÷Ô±£¬´Ó¶øÈòÙ×÷Ô±Á˽âϵͳÖз¢ÉúÁËʲà ......
/// <summary>
/// ¹ýÂ˱ê¼Ç
/// </summary>
/// <param name="NoHTML">°üÀ¨HTML£¬½Å±¾£¬Êý¾Ý¿â¹Ø¼ü×Ö£¬ÌØÊâ×Ö·ûµÄÔ´Âë </param>
/// <returns>ÒѾȥ³ý±ê¼ÇºóµÄÎÄ×Ö</returns>
&nbs ......