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

SQL Server ´æ´¢¹ý³Ì

SQL   Server   7.0   ÈëÃÅ(7)  
   
  ʱ¼ä£º2001/02/06   11:57   ×÷Õߣº¶¹¶¹   CHINAASP    
     
   
   
  ¡¡   ʹÓÃÁÙʱ±í   ÁÙʱ±íÊÇÔÚTempDBÖд´½¨µÄ±í¡£ÁÙʱ±íµÄÃû³Æ¶¼ÒÔ“#”¿ªÍ·¡£ÁÙʱ±íµÄ·¶Î§Îª´´½¨ÁÙʱ±íµÄÁ¬½Ó¡£ÒòΪ£¬ÁÙʱ±í²»ÄÜÔÚÁ½¸öÁ¬½ÓÖ®¼ä¹²Ïí£¬Ò»µ©Á¬½Ó¹Ø±Õ£¬ÁÙʱ±í¾Í»á±»¶ªÆú¡£Èç¹ûÁÙʱ±í±»´´½¨ÓÚ´æ´¢¹ý³ÌÖ®ÖУ¬ÔòÁÙʱ±íµÄ·¶Î§ÔÚ´æ´¢¹ý³ÌÖ®ÖУ¬»òÕß±»¸Ã´æ´¢¹ý³Ìµ÷ÓõÄÈκδ洢¹ý³ÌÖ®ÖС£Èç¹ûÐèÒªÔÚÁ¬½ÓÖ®¼ä¹²ÏíÁÙʱ±í£¬ÔòÐèҪʹÓÃÈ«¾ÖµÄÁÙʱ±í¡£È«¾ÖµÄÁÙʱ±íÒÔ“##”·ûºÅ¿ªÍ·£¬Ëü½«Ò»Ö±´æÔÚÓÚÊý¾Ý¿âÖУ¬Ö±µ½SQL   ServerÖØÐÂÆô¶¯¡£Ò»µ©ÕâÀàÁÙʱ±í´´½¨Ö®ºó£¬ËùÓеÄÓû§¶¼¿ÉÒÔ·ÃÎʵ½¡£ÔÚÁÙʱ±íÉϲ»ÄÜÃ÷È·µØÖ¸Ã÷ȨÏÞ¡£   ÁÙʱ±íÌṩÁË´æ´¢Öмä½á¹ûµÄÄÜÁ¦¡£ÓÐʱºò£¬ÁÙʱ±í»¹ÄÜͨ¹ý½«Ò»¸ö¸´ÔӵIJéѯ·Ö½â³ÉÁ½¸ö²éѯ¶ø»ñµÃÐÔÄܵĸÄÉÆ¡£Õâ¿ÉÒÔͨ¹ýÊ×ÏȽ«µÚÒ»¸ö²éѯµÄ½á¹û´æÔÚÁÙʱ±íÖУ¬È»ºóÔÚµÚ¶þ¸ö²éѯÖÐʹÓÃÁÙʱ±íÀ´ÊµÏÖ¡£µ±Ò»¸ö´ó±íÖеÄij¸ö×Ó¼¯ÔÚÒ»¸öÔÚ×ù¹ý³ÌÖÐʹÓöà´Îʱ£¬½¨ÒéʹÓÃÁÙʱ±í¡£ÔÚÕâÖÖÇé¿öÏ£¬ÔÚÁÙʱ±íÖб£³ÖÊý¾ÝµÄ×Ó¼¯£¬ÒÔÔÚËæºóµÄÁ¬½ÓÖÐʹÓã¬ÕâÑùÄÜ´ó´ó¸ÄÉÆÐÔÄÜ¡£»¹¿ÉÒÔÔÚÁÙʱ±íÖд´½¨Ë÷Òý¡£    
   
   
  ´Ó´æ´¢¹ý³ÌÖзµ»Ø½á¹û    
   
  ´Ó´æ´¢¹ý³ÌÖзµ»Ø½á¹ûÓÐÈýÖÖ·½Ê½£º    
   
  1¡¢   ·µ»Ø½á¹û¼¯    
   
  ÕâÊǿͻ§¶ËÓ¦ÓóÌÐò·µ»Ø½á¹ûµÄ×îͨÓõķ½·¨¡£½á¹û¼¯ÊÇͨ¹ýʹÓÃSELECTÓï¾äÑ¡ÔñÊý¾Ý²úÉúµÄ¡£½á¹û¼¯¿ÉÒÔ´ÓÓÀ¾Ã±í¡¢ÁÙʱ±í»ò¾Ö²¿±äÁ¿ÖвúÉú¡£½«½á¹û·µ»Øµ½ÁíÒ»¸ö´æ´¢¹ý³Ì²»ÊÇÒ»ÖÖÓÐЧµÄ·½·¨¡£´æ´¢¹ý³Ì²»ÄÜ·ÃÎÊÁíÒ»¸ö´æ´¢¹ý³Ì½¨Á¢µÄ½á¹û¼¯¡£    
   
  ÀýÈç´ÓÓÀ¾Ã±íÖзµ»Ø½á¹û¼¯£º    
   
  USE   pubs    
   
  GO    
   
 


Ïà¹ØÎĵµ£º

sql server Á¬½Ó³Ø

SQL Server ¼ÓÔØÇý¶¯ºÍurlµÄÓï¾äÔòΪ
Çý¶¯°üΪcom.microsoft.sqlserver.jdbc.SQLServerDriver
String driverName = "com.microsoft.sqlserver.jdbc.SQLServerDriver";
String dbURL = "jdbc:sqlserver://localhost:1433; DatabaseName=sample";
Çý¶¯°üΪcom.microsoft.jdbc.sqlserver.SQLServerDriverʱ
String driver ......

Sql Server2000,Sql Server2005Öеıí½á¹¹µÄÏà¹ØÐÅÏ¢

Sql Server2005µÄ:
SELECT
TableName=CASE WHEN C.column_id=1 THEN O.name ELSE N'' END,
TableDesc=ISNULL(CASE WHEN C.column_id=1 THEN PTB.[value] END,N''),
Column_id=C.column_id,
ColumnName=C.name,
PrimaryKey=ISNULL(IDX.PrimaryKey,N''),
[IDENTITY]=CASE WHEN C.is_identity=1 THEN N'√' ......

Sql Server 2008 Reporting ServicesϵÁУ¨Ò»£©

Ò»¡¢Á˽âReporting Services
     Sqlserver Reporting ServicesÊÇ΢ÈíµÄÊý¾Ý¿â±¨±íÉè¼Æ¹¤¾ß£¬Ëü¼¯³ÉÔÚ΢ÈíµÄÉÌÒµÖÇÄÜ¿ª·¢¹¤¾ß£ºSQL Server Business Intelligence Development StudioÖ®ÖУ¬Õâ¸ö¹¤¾ßÆäʵ¾ÍÊÇ´ó¼ÒÊìϤµÄVisual Studio£¬ÀûÓÃReporting ServicesÎÒôÄܹ»¸ßЧµÄ¿ª·¢Êý¾Ý±¨±í£¬Reporting S ......

SQL Server 2000 Êý¾Ý¿âͬ²½(×ªÔØ)


ΪʲôҪͬ²½SQL Server 2000 Êý¾Ý¿â£¬Ëü¶¼ÓÃÔÚʲô³¡ºÏ
Êý¾Ýʵʱ±¸·Ýͬ²½£¬Êý¾Ý¿â·þÎñÆ÷³öÎÊÌâʱÎÒÃÇÒ²ÓÐÆäÕý³£¹¤×÷ʱµÄ±¸·Ý
Êý¾Ýʵʱ±¸·Ýͬ²½£¬Ò»Ì¨·þÎñÆ÷¸ºÔز»Æðʱ£¬¿ÉÒÔÓÃÀ´×ö¸ºÔؾùºâ
Êý¾Ýʵʱ±¸·Ýͬ²½£¬Êý¾Ý¿â·þÎñÆ÷¿ÉÒÔÎÞ¼ä¶Ï£¬ÎÞËðÊ§Ç¨ÒÆ
Ö÷·þÎñÆ÷±»¹¥»÷»òµ±»úʱÁíһ̨·þÎñͬ²½»ú¿ÉÒÔÓ¦¼±
¡£¡£¡£¡£¡£¿ÉÒÔ˵ ......

sqlǶÌ××Ó²éѯ

×Ó²éѯ£º
ʹÓÃ×Ó²éѯµÄÔ­Ôò
1.Ò»¸ö×Ó²éѯ±ØÐë·ÅÔÚÔ²À¨ºÅÖС£
2.½«×Ó²éѯ·ÅÔڱȽÏÌõ¼þµÄÓÒ±ßÒÔÔö¼Ó¿É¶ÁÐÔ¡£
×Ó²éѯ²»°üº¬ ORDER BY ×Ӿ䡣¶ÔÒ»¸ö SELECT Óï¾äÖ»ÄÜÓÃÒ»¸ö ORDER BY ×Ӿ䣬
²¢ÇÒÈç¹ûÖ¸¶¨ÁËËü¾Í±ØÐë·ÅÔÚÖ÷ SELECT Óï¾äµÄ×îºó¡£
ORDER BY ×Ó¾ä¿ÉÒÔʹÓ㬲¢ÇÒÔÚ½øÐÐ Top-N ·ÖÎöʱÊDZØÐëµÄ¡£
3.ÔÚ×Ó² ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ