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

¡¾Çó½Ì¡¿SQLServer´´½¨²»ÁËÐÂÓû§

Êý¾Ý¿âÊǰ²×°VS2005×Ô´øµÄÄǸöSQLServer2005¡£Í¼ÐιÜÀí¹¤¾ßÊÇ—>SQL Server Management Studio Express¡£

ÎÒÏÈÊÇÓÃWindowsÉí·ÝÑé֤ģʽ½øÈ¥¡£ µã—>"°²È«ÐÔ" È»ºóÓÒ¼ü"µÇ¼Ãû" È»ºóÑ¡Ôñ"н¨µÇ¼Ãû"
È»ºóµ¯³ö¸ö½çÃæ¡£  ÎÒÔٵǽÃûÄǸö¿òдÁËabcdef È»ºóÑ¡ÔñSQL ServerÉí·ÝÑéÖ¤  ÃÜÂëдÁË"1234567".
È»ºóÎÒ°ÑÏÂÃæµÄÄÇÈý¸öµ¥Ñ¡ÖеÄ×îºóÒ»¸ö¹´µô(Óû§Ï´εǼʱ±ØÐë¸ü¸ÄÃÜÂë)¡£
È»ºóÎÒµãÏÂÃæµÄ--->¡°È·¶¨¡±¡£  ½á¹ûÓôÃÆµÄÊ·¢ÉúÀ²¡£Ìáʾ³ö´í(³ö´íÐÅÏ¢ÎҼDz»ÇåÀ²£¡×òÌìÍíÉÏÔÚ¼ÒŪµÄ)£¡
Çë½Ì¸ßÊÖ£¬µ½µ×ÊÇÄijöÎÊÌâÀ²¡£¸ÃÈçºÎ½â¾ö°¡£¡
ллÀ²£¡£¡¸Ð¼¤£¡£¡£¡
Ŷ

ÊDz»ÊÇÌáʾûÓÐȨÏÞ
ÄãÓùÜÀíÔ±Õ˺ÅÊÔÊÔ

ÎÒÊÔÁË Ã»±¨´í ²»ÖªµÀÄãÄĶù´ÓÁË

Äãʲô´íÎó¶¼²»¼ÇÇå³þ??

ÒýÓÃ
ÎÒÊÔÁË Ã»±¨´í ²»ÖªµÀÄãÄĶù´ÓÁË

Êǰ¡ ÎÒÓù«Ë¾µçÄÔÊÔÁËÏÂҲû±¨´í£¬µ½¼ÒÀïÄǵçÄԾͳöÎÊÌâ ²»ÖªµÀÕ¦»ØÊÂ

ÒýÓÃ
ÊDz»ÊÇÌáʾûÓÐȨÏÞ
ÄãÓùÜÀíÔ±Õ˺ÅÊÔÊÔ

ÎÒÊÇÓùÜÀíÔ±Õ˺ŵð¡ ¹À¼ÆÎÒװɶ¶«Î÷ºÍÊý¾Ý¿âÓгåÍ»ÁË ²»ÖªµÀ֨װºóºÃ²»ºÃʹ »Ø¼ÒÊÔÊÔ


»Ø¼Ò¿´Ìáʾʲô´íÔÙ·¢Âï¡£²»ÖªµÀʲô´í£¬½ÐÈ˼ÒÔõô°ïÄã°¡£¿
{{


Ïà¹ØÎÊ´ð£º

sqlserver Êý¾ÝºÏ²¢ÎÊÌâ

ÏÈÓÉÈçÏÂsqlÓï¾ä
select  A,B,C from table1
union
select  A,B,C from table2
order by A, C asc
µÃµ½½á¹ûÈçÏ£º
  A        B      &nbs ......

Óг¥ÇósqlserverÊý¾Ý¿âÉè¼Æ:ÓÐÏßµçÊÓ

ÐèҪʹÓÃSQL Server2000»ò2005
ÐèÒªÉè¼ÆÊý¾ÝÓÐЧÑéÖ¤,·Àֹ¼Èë²»ºÏ·¨Êý¾Ý
ÐèÒªÉè¼Æ´æ´¢¹ý³Ì»ò×Ô¶¨Ò庯ÊýÍê³ÉÊý¾ÝµÄ¼Èë\ÐÞ¸Ä\ɾ³ý\ͳ¼Æ\²éѯ

Êý¾Ý¿â´ó²¿·Ö±íÎÒÒѾ­½¨Á¢,Ö»ÊǸ¨ÖúÐÔµÄС±í½¨Á¢µÄ»¹²»È« ......

ÈçºÎÉèÖÃSqlserverÊý¾Ý¿âÈÕÖ¾Ôö³¤·½Ê½

ÈçÌâ¡£
ÎÒÏ붨ÆÚÖ´ÐгÌÐò£¬É¾³ý²»ÓõÄÊý¾Ý£¬ÊÕËõÒ»ÏÂÊý¾Ý¿â£¬Æ½Ê±Ê¹ÓõÄʱºò£¬ÈÕÖ¾×î´óÎļþ´óСΪÏÞÖÆ200MB£¬
µ«ÊÇÊÕËõµÄʱºò£¬»á²úÉú´óÁ¿ÈÕÖ¾£¬Èç¹û³¬¹ýÏÞÖÆ£¬ÔòÊÕËõÊý¾Ý¿âʱ»áʧ°Ü£¬ÎÒÏë¸ÄΪ×î´óÎļþ´óС²»Ê ......

sqlserverÖРģʹÓÃ

ÄÜ·ñ¸ø³öÒ»¸öÀý×Ó£¬ÔÚÉÏÊý¾ÝºÜ¶àµÄʱºò£¬¸ø³öÄ£µÄʹÓÃʵÀý
£¨´´½¨¡¢²éѯ£©
SQL code:
----ÎÒÊÇÀ´²ä·ÖµÄ!
create table cj(ѧºÅ varchar(10), ¿Î³ÌºÅ varchar(10), ³É¼¨ int);
insert into cj(ѧºÅ,¿Î³ÌºÅ,³É ......

¡¾Çó½Ì¡¿SQLServer´´½¨²»ÁËÐÂÓû§

Êý¾Ý¿âÊǰ²×°VS2005×Ô´øµÄÄǸöSQLServer2005¡£Í¼ÐιÜÀí¹¤¾ßÊÇ—>SQL Server Management Studio Express¡£

ÎÒÏÈÊÇÓÃWindowsÉí·ÝÑé֤ģʽ½øÈ¥¡£ µã—>"°²È«ÐÔ" È»ºóÓÒ¼ü"µÇ¼Ãû ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ