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

Ö´ÐÐSQLÈ¡PostgreSQLÊý¾Ý¿â»ò±í´óС

ÔÚPostgreSQL8.1.3ÉÏ¿ÉÒÔwork
1. È¡Êý¾Ý¿â´óС
SELECT pg_size_pretty(pg_database_size('somedatabase')) As fulldbsize
2. È¡±í´óС
SELECT pg_size_pretty(pg_total_relation_size('someschema.sometable')) As fulltblsize, pg_size_pretty(pg_relation_size('someschema.sometable')) As justthetblsize
Ô­Ìù£º
http://www.postgresonline.com/journal/index.php?/archives/110-Determining-size-of-database,-schema,-tables,-and-geometry.html


Ïà¹ØÎĵµ£º

SQL ×óÍâÁ¬½Ó£¬ÓÒÍâÁ¬½Ó£¬È«Á¬½Ó£¬ÄÚÁ¬½Ó

 Áª½ÓÌõ¼þ¿ÉÔÚ   from   »ò   WHERE   ×Ó¾äÖÐÖ¸¶¨£¬½¨ÒéÔÚ   from   ×Ó¾äÖÐÖ¸¶¨Áª½ÓÌõ¼þ¡£WHERE   ºÍ   HAVING   ×Ó¾äÒ²¿ÉÒÔ°üº¬ËÑË÷Ìõ¼þ£¬ÒÔ½øÒ»²½É¸Ñ¡Áª½ÓÌõ¼þËùÑ¡µÄÐС£   
   
Áª½Ó¿É·ÖΪÒÔϼ¸Àࣺ      ......

Ô¶³Ì±¸·ÝSQL Server 2005Êý¾Ý¿â

 ½ñÌìÖÕÓÚ°ÑÕâ¸öÎÊÌâ¸ø½â¾öÁË£º
²Î¿¼ÎÄÕ£ºhttp://blog.csdn.net/long2006sky/archive/2007/04/23/1576583.aspx
ʵÀý˵Ã÷£º
           »·¾³£ºwin2k+sqlserver 2K+²éѯ·ÖÎöÆ÷
           SQLSERVER·þÎñʵÀý ......

SQLÈÕÆÚ¸ñʽ»¯

Sql Server ÖÐÒ»¸ö·Ç³£Ç¿´óµÄÈÕÆÚ¸ñʽ»¯º¯Êý
Select CONVERT(varchar(100), GETDATE(), 0): 05 16 2006 10:57AM
Select CONVERT(varchar(100), GETDATE(), 1): 05/16/06
Select CONVERT(varchar(100), GETDATE(), 2): 06.05.16
Select CONVERT(varchar(100), GETDATE(), 3): 16/05/06
Select CONVE ......

sql È¡·´

 update anketo1 set fb = substring('10',fb+1,1) WHERE id =5
ºóÀ´ÎÊÁËBM,BM˵ֱ½ÓÈ¡·´
update anketo1 set fb = ~ fb WHERE id =5
ÎÒ¸æËßÁËBMÓÃsubstringÒ²¿ÉÒÔ.
BM˵:"Õâ¼Ò»ïÀ÷º¦£¬ÕâÒ²ÄÜÏë³ö,ÕâÊôÓÚаÃÅÎ书."
×îºóÓÖÏëµ½ÓÃABSÈ¡¾ø¶ÔÖµÒ²¿ÉÒÔ
update anketo1 set fb = abs(fb-1)
ÎÒ¾õµÃ²»¹ÜÊÇʲôÎ书,ÄÜÖ ......

ÅäÖÃʹÓà SQL ServerÌṩ³ÌÐò ¡£

 ÅäÖÃʹÓà SQL ServerÌṩ³ÌÐò
 <configuration>
  <system.web> <-- ¸ü¸ÄÌṩ³ÌÐòÅäÖ㺠-->
    <membership defaultProvider="AspNetSqlProvider" />
  </system.web>
  <membership> <--ÅäÖÃÌṩ³ÌÐò -->
  <prov ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ