Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

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 ´úÂëÒ³À´½âÊͺÍÏÔʾ¸ÃÁ


Ïà¹ØÎÊ´ð£º

sqlССµÄÒÉÎÊ - .NET¼¼Êõ / C#

¿ÉÄÜÒòΪ¹¤×÷µÄÔ­Òò ½Ó´¥Êý¾Ý¿âÕâ¿é±È½ÏÉÙ£¬Ö®Ç°¶¼ÊÇ×ö³ÌÐòÕâ¿é£¬Êý¾Ý¿âÕâ¿é¶¼ÓÐרÃŵÄÈËÀ´×ö ·Ö¹¤¶¼ºÜÃ÷ϸ ËùÒÔ¶ÔÊý¾Ý¿âÕâÒ»¿éÍêÈ«²»Á˽⡣ǰ¶Îʱ¼ä È¥ÃæÊÔÁ˼¸¼Ò¹«Ë¾ ¼¸ºõ¶¼ÊÇÔÚÊý¾Ý¿âÕâ¿é¹ÒµôµÄ Á¬¸ö¼òµ¥µÄSQ ......

SQLÈçºÎÓÅ»¯ÎÊÌâ - MS-SQL Server / ÒÉÄÑÎÊÌâ

½ñÌì×öÁËÒ»¸ö´æ´¢¹ý³Ì   »·¾³ÊÇSQL2000Êý¾Ý¿â  
´óÖÂÈçÏÂ
½¨Á¢ÁÙʱ±í
¶¨ÒåÔ±¹¤Óαê
        Ñ­»·Ô±¹¤£¨ÊôÓÚ1¸ö¹«Ë¾)  
        ......

¹ØÓÚVbÖÐsqlÓï¾äµÄд·¨£¨100·Ö£© - Java / Web ¿ª·¢

Çó¸övbÖеÄsqlÓï¾äµÄд·¨£¬´ÎsqlÓï¾äµÄÓ÷¨ÊÇ·ÖÒ³³ÌÐò
ÎÒдµÄÈçÏ£ºÆäÖÐAÊÇÓÃÀ´½ÓÊÕÿҳÏÔʾµÄ¼Ç¼µÄÌõÊý£¬BÊÇÓÃÀ´½ÓÊÕÏÔʾµÄµ±Ç°µÄÒ³Ãæ.
sqltext="select top A * from log where id not in(select top ( ......

sql ÎÊÌâ - MS-SQL Server / »ù´¡Àà

ÐèÇóÈçÏ£º
ѧԺ 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 ......

¹ØÓÚSqlµÄÎÊÌâ - .NET¼¼Êõ / ASP.NET

½«Ò»¸ö²éѯÓï¾ä¸³¸øÒ»¸ö±äÁ¿£¬ÈçÏ£º
DECLARE @STR NVARCHAR(MAX)
SET @STR='SELECT * from SALE_PROD'
ÔõôÑù²ÅÄÜÖ´ÐÐËüÄØ£¿
Çë¸ßÊÖ£¬ÈÊÐÖ£¬ÏÀ½ã°ï°ïæ°¡


¶àл£¬¿ÉÒÔÀ²£¬¸ßÊÖ°¡

Ö±½ÓÖ´ÐоÍÐÐÁË

exec ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ