¡¾Çó½Ì¡¿SQLServer´´½¨²»ÁËÐÂÓû§
Êý¾Ý¿âÊǰ²×°VS2005×Ô´øµÄÄǸöSQLServer2005¡£Í¼ÐιÜÀí¹¤¾ßÊÇ—>SQL Server Management Studio Express¡£
ÎÒÏÈÊÇÓÃWindowsÉí·ÝÑé֤ģʽ½øÈ¥¡£ µã—>"°²È«ÐÔ" È»ºóÓÒ¼ü"µÇ¼Ãû" È»ºóÑ¡Ôñ"н¨µÇ¼Ãû"
È»ºóµ¯³ö¸ö½çÃæ¡£ ÎÒÔٵǽÃûÄǸö¿òдÁËabcdef È»ºóÑ¡ÔñSQL ServerÉí·ÝÑéÖ¤ ÃÜÂëдÁË"1234567".
È»ºóÎÒ°ÑÏÂÃæµÄÄÇÈý¸öµ¥Ñ¡ÖеÄ×îºóÒ»¸ö¹´µô(Óû§Ï´εǼʱ±ØÐë¸ü¸ÄÃÜÂë)¡£
È»ºóÎÒµãÏÂÃæµÄ--->¡°È·¶¨¡±¡£ ½á¹ûÓôÃÆµÄÊ·¢ÉúÀ²¡£Ìáʾ³ö´í(³ö´íÐÅÏ¢ÎҼDz»ÇåÀ²£¡×òÌìÍíÉÏÔÚ¼ÒŪµÄ)£¡
Çë½Ì¸ßÊÖ£¬µ½µ×ÊÇÄijöÎÊÌâÀ²¡£¸ÃÈçºÎ½â¾ö°¡£¡
ллÀ²£¡£¡¸Ð¼¤£¡£¡£¡
Ŷ
ÊDz»ÊÇÌáʾûÓÐȨÏÞ
ÄãÓùÜÀíÔ±Õ˺ÅÊÔÊÔ
ÎÒÊÔÁË Ã»±¨´í ²»ÖªµÀÄãÄĶù´ÓÁË
Äãʲô´íÎó¶¼²»¼ÇÇå³þ??
Êǰ¡ ÎÒÓù«Ë¾µçÄÔÊÔÁËÏÂҲû±¨´í£¬µ½¼ÒÀïÄǵçÄԾͳöÎÊÌâ ²»ÖªµÀÕ¦»ØÊÂ
ÎÒÊÇÓùÜÀíÔ±Õ˺ŵð¡ ¹À¼ÆÎÒװɶ¶«Î÷ºÍÊý¾Ý¿âÓгåÍ»ÁË ²»ÖªµÀ֨װºóºÃ²»ºÃʹ »Ø¼ÒÊÔÊÔ
»Ø¼Ò¿´Ìáʾʲô´íÔÙ·¢Âï¡£²»ÖªµÀʲô´í£¬½ÐÈ˼ÒÔõô°ïÄã°¡£¿
{{
Ïà¹ØÎÊ´ð£º
ÏÈÓÉÈçÏÂsqlÓï¾ä
select A,B,C from table1
union
select A,B,C from table2
order by A, C asc
µÃµ½½á¹ûÈçÏ£º
A B &nbs ......
ÐèҪʹÓÃSQL Server2000»ò2005
ÐèÒªÉè¼ÆÊý¾ÝÓÐЧÑéÖ¤,·Àֹ¼Èë²»ºÏ·¨Êý¾Ý
ÐèÒªÉè¼Æ´æ´¢¹ý³Ì»ò×Ô¶¨Ò庯ÊýÍê³ÉÊý¾ÝµÄ¼Èë\ÐÞ¸Ä\ɾ³ý\ͳ¼Æ\²éѯ
Êý¾Ý¿â´ó²¿·Ö±íÎÒÒѾ½¨Á¢,Ö»ÊǸ¨ÖúÐÔµÄС±í½¨Á¢µÄ»¹²»È«
......
ÈçÌâ¡£
ÎÒÏ붨ÆÚÖ´ÐгÌÐò£¬É¾³ý²»ÓõÄÊý¾Ý£¬ÊÕËõÒ»ÏÂÊý¾Ý¿â£¬Æ½Ê±Ê¹ÓõÄʱºò£¬ÈÕÖ¾×î´óÎļþ´óСΪÏÞÖÆ200MB£¬
µ«ÊÇÊÕËõµÄʱºò£¬»á²úÉú´óÁ¿ÈÕÖ¾£¬Èç¹û³¬¹ýÏÞÖÆ£¬ÔòÊÕËõÊý¾Ý¿âʱ»áʧ°Ü£¬ÎÒÏë¸ÄΪ×î´óÎļþ´óС²»Ê ......
ÄÜ·ñ¸ø³öÒ»¸öÀý×Ó£¬ÔÚÉÏÊý¾ÝºÜ¶àµÄʱºò£¬¸ø³öÄ£µÄʹÓÃʵÀý
£¨´´½¨¡¢²éѯ£©
SQL code:
----ÎÒÊÇÀ´²ä·ÖµÄ!
create table cj(ѧºÅ varchar(10), ¿Î³ÌºÅ varchar(10), ³É¼¨ int);
insert into cj(ѧºÅ,¿Î³ÌºÅ,³É ......
Êý¾Ý¿âÊǰ²×°VS2005×Ô´øµÄÄǸöSQLServer2005¡£Í¼ÐιÜÀí¹¤¾ßÊÇ—>SQL Server Management Studio Express¡£
ÎÒÏÈÊÇÓÃWindowsÉí·ÝÑé֤ģʽ½øÈ¥¡£ µã—>"°²È«ÐÔ" È»ºóÓÒ¼ü"µÇ¼Ãû ......