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

¿ª·¢¸¨Öú¹¤¾ß£ºSQLÎĸñʽ»¯¹¤¾ßSQLinFormpro_Desktop

    ÔÚÓйØÊý¾Ý¿âµÄÏîÄ¿¿ª·¢ÖУ¬±àÂ룬bugÐ޸ĵȵȣ¬¶¼ÐèÒª²é¿´²Ù×÷Ïà¹ØµÄSQLÎÄ£¬Èç¹ûSQLÎıȽϸ´Ôӵϰ£¬ÎÒÃÇ×Ô¼ºÅŰæ·Ç³£Âé·³£¬Í¬Ê±Ò²ºÜ»¨·Ñʱ¼ä¡£¿ÉÄÜÓеĹ«Ë¾×Ô¼º¿ª·¢Á˸ñʽ»¯¹¤¾ß»òÕß¹ºÂòÁ˸ñʽ»¯¹¤¾ßÈí¼þ¡£ÓÐÁ˸ñʽ¹¤¾ßÎÒÃǾͽÚÊ¡ÁËÅŰæÊ±¼ä¡£
    ½éÉÜÒ»ÏÂSQLinFormpro_Desktop£¨http://www.sqlinform.com/license.phtml
£©¸ñʽ»¯¹¤¾ß¡£ÓÐÔÚÏß°æºÍ×ÀÃæ°æ¡£×ÀÃæ°æËäÈ»Ã²ËÆÒª»¨Ç®£¬²»¹ýÏÂÔØµÄ×ÀÃæ°æ¿ÉÒÔÃâ·ÑʹÓá£ÔÚÍøÒ³µÄDownload & Install Desktop VersionµÄÏÂÃæµã»÷ÏÂÔØ¡£ÓжÔÓ¦JRE1.5£¬JRE1.6µÄÁ½¸ö°æ±¾¡£ÏÂÔØºóÎļþÊÇÒÔ.jarΪºó׺µÄÎļþ¡£Ë«»÷Æô¶¯£¬µã»÷×óÉϽǵÄACCEPT°´Å¥¡£¿½±´Òª¸ñʽ»¯µÄSQLÎĵ½±à¼­¿òÖУ¬µã»÷Format°´Å¥¾Í¿ÉÒÔ¸ñʽ»¯ÁË¡£
    ¿ÉÒÔ×Ô¼ºÉèÖøñʽ»¯µÄ¹æÔò£¬Èç»»ÐйæÔò£¬È¥µô¿Õ¸ñ£¬¶ÔÆëµÈµÈ¡£¸ñʽ»¯µÄÀý×ÓÈçͼËùʾ£º


Ïà¹ØÎĵµ£º

SQLÅжÏ×Ö¶ÎÀàÐÍ

-->Title:Generating test data
-->Author:wufeng4552
-->Date :2009-09-25 09:56:07
if object_id('tb')is not null drop table tb
go
create table tb(ID int,name text)
insert tb select 1,'test'
go
--·½·¨1
select sql_variant_property(ID,'BaseType') from tb
--·½·¨2
select object_name(ID)± ......

³É¼¨µ¥¡¢Òµ¼¨±íSQL(Ò»¸ö×ݱí±äºá±í Ò»¸öÓÿª´°º¯Êý)

 Ô­Ê¼±í£º
name            course              score
-----------------------------------------
ÕÅÈý            ÓïÎÄ                80
ÕÅÈý    & ......

ÔõôÔö¼ÓSQL ServerÁ¬½ÓÊý

ÔõôÔö¼ÓSQL ServerÁ¬½ÓÊý
1. ¿´²Ù×÷ƽ̨µÄ連½Ó數ÊǶàÉÙ
   ¿ØÖÆÌ¨µÄÊÚ權¿´¿´
2. 進GENERAL¿´¿´SQL SERVER USERS CONNECTIONS
    Ôö´ó¼´¿É
sp_configure 'number of connection'
go ......

ÐÞ¸Äsql server µÄÁ¬½ÓÊý

 ÈçºÎÐÞ¸ÄSQL ServerµÄÁ¬½ÓÊý
ÎÒ°ÑSQL   Server   7.0µÄÓû§Á¬½ÓÊýÉèΪ1ºó£¬Êý¾Ý¿â¾ÍÔÙÒ²Á¬²»ÉÏÁË£¬ËùÒÔҲû°ì·¨ÐÞ¸ÄÁ¬½ÓÊý  
  ÇëÎÊÓÐʲô°ì·¨ÄÜÐÞ¸ÄÁ¬½ÓÊý£¿
ÔÚserver   µÄÊôÐÔÀïÃæÓиöconnetctions     µÄ  
   
  maximun     concurr ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ