sql Êý¾Ý²åÈëÎÊÌâ - MS-SQL Server / »ù´¡Àà
create table Poem1 ( LineText nvarchar(50) primary key ) insert into Poem1 values('ݺÌä°¶ÁøÅª´ºÇçÒ¹ÔÂÃ÷'); insert into Poem1 values('ÏãÁ«±ÌË®¶¯·çÁ¹ÏÄÈÕ³¤'); insert into Poem1 values('Çï½³þÑãËÞɳÖÞdzˮÁ÷'); insert into Poem1 values('ºì¯͸̿Ö˺®¶¬ÓùÑ©·ç'); ÉÏÃæÎÒ°ÑÊý¾Ý²åÈëºó£¬µ«ÊÇÊý¾ÝÏÔʾȴΪ£º ºì¯͸̿Ö˺®¶¬ÓùÑ©·ç Çï½³þÑãËÞɳÖÞdzˮÁ÷ ÏãÁ«±ÌË®¶¯·çÁ¹ÏÄÈÕ³¤ ݺÌä°¶ÁøÅª´ºÇçÒ¹ÔÂÃ÷ µ¹×Å´æ´¢¡£ÇëÎÊÕâÊÇΪʲô£¿£¿ÒªÈçºÎÐ޸IJÅÄÜÊÇÊý¾ÝÄܹ»°´ÔÀ´µÄ˳Ðò´æ´¢£¿
ѧϰÁË£¡ 2µÄ´óÏÀ£ºÎªÊ²Ã´¾Û¼¯Ë÷Òý»á³öÏÖÕâÖÖÇé¿ö£¿ÒýÓà ѧϰÁË£¡ 2µÄ´óÏÀ£ºÎªÊ²Ã´¾Û¼¯Ë÷Òý»á³öÏÖÕâÖÖÇé¿ö£¿ Õâ¸öÉæ¼°µ½ÅÅÐò¹æÔòÎÊÌ⣬¿ÉÒԲο¼Ò»ÏÂÓйØÅÅÐò¹æÔòµÄ×ÊÁÏ¡£ÏÂÃæÊÇÁª»ú´ÔÊéµÄÒ»¶Î»°£¬¸ü¶àµ½Áª»ú²Î¿¼Ïà¹ØÊ¾Àý£º ÅÅÐò¹æÔò¸ù¾ÝÌØ¶¨ÓïÑÔºÍÇøÓòÉèÖõıê×¼Ö¸¶¨¶Ô×Ö·û´®Êý¾Ý½øÐÐÅÅÐòºÍ±È½ÏµÄ¹æÔò¡£ÒÔ ORDER BY ×Ó¾äΪÀý£ºÈç¹û°´ÉýÐòÅÅÁУ¬ËµÓ¢ÓïµÄÈËÈÏΪ×Ö·û´® Chiapas Ó¦ÅÅÔÚ Colima ֮ǰ¡£µ«ÊÇ£¬¶ÔÓÚÔÚÄ«Î÷¸ç˵Î÷°àÑÀÓïµÄÈËÀ´Ëµ£¬ËûÃÇ»áÈÏΪÒÔ¡°Ch¡±¿ªÍ·µÄµ¥´ÊÓ¦ÏÔʾÔÚÒÔ¡°C¡±¿ªÍ·µÄµ¥´ÊÁбíµÄĩβ¡£ÅÅÐò¹æÔò¹æ¶¨ÁËÕâЩÅÅÐòºÍ±È½Ï¹æÔò¡£Latin_1 General ÅÅÐò¹æÔòÔÚ ORDER BY ASC ×Ó¾äÖн«¡°Chiapas¡±ÅÅÔÚ¡°Colima¡±Ö®Ç°£¬¶ø Traditional_Spanish ÅÅÐò¹æÔò½«¡°Chiapas¡±ÅÅÔÚ¡°Colima¡±Ö®ºó¡£ µ±Îª·Ç Unicode ×Ö·ûÊý¾Ý£¨ÀýÈç char¡¢varchar ºÍ text Êý¾Ý£©Ö¸¶¨ÅÅÐò¹æÔòʱ£¬Ä³Ìض¨´úÂëÒ³½«Óë¸ÃÅÅÐò¹æÔòÏà¹ØÁª¡£ÀýÈ磬Èç¹û±íÖÐµÄ char ÁÐÊÇʹÓà Latin1_General ÅÅÐò¹æÔò¶¨ÒåµÄ£¬Ôò SQL Server ½«Ê¹Óà 1252 ´úÂëÒ³À´½âÊͺÍÏÔʾ¸ÃÁ
Ïà¹ØÎÊ´ð£º
¿ÉÄÜÒòΪ¹¤×÷µÄÔÒò ½Ó´¥Êý¾Ý¿âÕâ¿é±È½ÏÉÙ£¬Ö®Ç°¶¼ÊÇ×ö³ÌÐòÕâ¿é£¬Êý¾Ý¿âÕâ¿é¶¼ÓÐרÃŵÄÈËÀ´×ö ·Ö¹¤¶¼ºÜÃ÷ϸ ËùÒÔ¶ÔÊý¾Ý¿âÕâÒ»¿éÍêÈ«²»Á˽⡣ǰ¶Îʱ¼ä È¥ÃæÊÔÁ˼¸¼Ò¹«Ë¾ ¼¸ºõ¶¼ÊÇÔÚÊý¾Ý¿âÕâ¿é¹ÒµôµÄ Á¬¸ö¼òµ¥µÄSQ ......
½ñÌì×öÁËÒ»¸ö´æ´¢¹ý³Ì »·¾³ÊÇSQL2000Êý¾Ý¿â ´óÖÂÈçÏ ½¨Á¢ÁÙʱ±í ¶¨ÒåÔ±¹¤Óαê Ñ»·Ô±¹¤£¨ÊôÓÚ1¸ö¹«Ë¾) ......
Çó¸övbÖеÄsqlÓï¾äµÄд·¨£¬´ÎsqlÓï¾äµÄÓ÷¨ÊÇ·ÖÒ³³ÌÐò ÎÒдµÄÈçÏ£ºÆäÖÐAÊÇÓÃÀ´½ÓÊÕÿҳÏÔʾµÄ¼Ç¼µÄÌõÊý£¬BÊÇÓÃÀ´½ÓÊÕÏÔʾµÄµ±Ç°µÄÒ³Ãæ. sqltext="select top A * from log where id not in(select top ( ......
ÐèÇóÈçÏ£º ѧԺ academy£¨aid,aname£© °à¼¶ class£¨cid,cname,aid£© ѧÉú stu(sid,sname,aid,cid) סËÞÇø region(rid,rname) ËÞÉáÂ¥ build(bid,rid,bnote) bnoteÊÇ¡®ÄС¯/¡®Å®¡¯ ËÞÉá dorm(did,rid,bid£¬bedn ......
½«Ò»¸ö²éѯÓï¾ä¸³¸øÒ»¸ö±äÁ¿£¬ÈçÏ£º DECLARE @STR NVARCHAR(MAX) SET @STR='SELECT * from SALE_PROD' ÔõôÑù²ÅÄÜÖ´ÐÐËüÄØ£¿ Çë¸ßÊÖ£¬ÈÊÐÖ£¬ÏÀ½ã°ï°ïæ°¡ ¶àл£¬¿ÉÒÔÀ²£¬¸ßÊÖ°¡ Ö±½ÓÖ´ÐоÍÐÐÁË exec ......