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

SQL Server 2005 ²»ÔÊÐíÔ¶³ÌÁ¬½Ó½â¾ö·½·¨

SQL Server 2005 ²»ÔÊÐíÔ¶³ÌÁ¬½Ó½â¾ö·½·¨
 
¸Õ¸Õ°²×°µÄÊý¾Ý¿âϵͳ£¬°´ÕÕĬÈÏ°²×°µÄ»°£¬ºÜ¿ÉÄÜÔÚ½øÐÐÔ¶³ÌÁ¬½Óʱ±¨´í£¬Í¨³£ÊÇ´íÎó:"ÔÚÁ¬½Óµ½ SQL Server 2005 ʱ£¬
ÔÚĬÈϵÄÉèÖÃÏ SQL Server ²»ÔÊÐí½øÐÐÔ¶³ÌÁ¬½Ó¿ÉÄܻᵼÖ´Ëʧ°Ü¡£
(provider: ÃüÃû¹ÜµÀÌṩ³ÌÐò, error: 40 - ÎÞ·¨´ò¿ªµ½ SQL Server µÄÁ¬½Ó) "ËÑMSDN£¬ÉÏÃæÓÐһƬ»úÆ÷·­ÒëµÄÎÄÕ£¬ÊÇÔÚÈÃÈËÄÑÒÔÃ÷°×£¬
ÏÖÔÚ×ܽáÈçÏ£ºÃ÷°×ÁËSQL ServerÊǸöÍøÂçÊý¾Ý¿â¾Í¿ÉÓ­Èжø½âÁË£¬¼òµ¥µÄ·ÖΪÏÂÃæµÄ¼¯ÖÐÇé¿ö¡£
1. Êý¾Ý¿âÒýÇæûÓÐÆô¶¯¡£
ÓÐÁ½ÖÖÆô¶¯·½Ê½:
(1)¿ªÊ¼->³ÌÐò->Microsoft SQL Server 2005->SQL Server 2005ÍâΧӦÓÃÅäÖÃÆ÷,ÔÚ´ò¿ªµÄ½çÃæµ¥»÷"·þÎñµÄÁ¬½ÓµÄÍâΧӦÓÃÅäÖÃÆ÷",
ÔÚ´ò¿ªµÄ½çÃæÖÐÕÒµ½Database Engine,µ¥»÷"·þÎñ",ÔÚÓÒ²à²é¿´ÊÇ·ñÒÑÆô¶¯,Èç¹ûûÓÐÆô¶¯¿Éµ¥»÷"Æô¶¯",²¢È·±£"Æô¶¯ÀàÐÍ"Ϊ×Ô¶¯,²»ÒªÎªÊÖ¶¯,
·ñÔòÏ´οª»úʱÓÖÒªÊÖ¶¯Æô¶¯;
(2)¿É´ò¿ª:¿ªÊ¼->³ÌÐò->Microsoft SQL Server 2005->ÅäÖù¤¾ß->SQL Server Configuration Manager,Ñ¡ÖÐSQL Server 2005·þÎñ
ÖÐSQL Server(MSSQLSERVER) ,²¢µ¥»÷¹¤¾ßÀ¸ÖеÄ"Æô¶¯·þÎñ"°´Å¥°Ñ·þÎñ״̬¸ÄΪÆô¶¯;
ʹÓÃÉÏÃæÁ½ÖÖ·½Ê½Ê±,ÓÐʱºòÔÚÆô¶¯µÄʱºò¿ÉÄÜ»á³öÏÖ´íÎó,²»ÄÜÆô¶¯,Õâʱ¾ÍÒª²é¿´"SQL Server 2005ÅäÖùÜÀíÆ÷"ÖеÄSQL Server 2005Íø
ÂçÅäÖÃ->MSSQLSERVERЭÒéÖеÄVIAÊÇ·ñÒÑÆôÓÃ,Èç¹ûÒÑÆôÓÃ,Ôò°ÑËü½ûÖ¹.È»ºóÔÙÖ´ÐÐÉÏÊöÒ»ÖÖ·½Ê½²Ù×÷¾Í¿ÉÒÔÁË.
2. ÊÇ·ñÒѾ­ÔÊÐíÔ¶³ÌÁ¬½Ó¡£
Õâ¸ö²¿·Ö¿ÉÒÔ¼òµ¥µÄ·ÖΪ4¸ö·½Ã棬·Ö±ðÊÇÔÚ SQL ServerÉÏÆôÓÃÔ¶³ÌÁ¬½Ó¡¢ÆôÓÃSQL Server ä¯ÀÀ·þÎñ¡¢ÔÚWindows ·À»ðǽÖÐΪ
SQL Server 2005 ´´½¨ÀýÍâºÍÔÚWindows ·À»ðǽÖÐΪ“SQLBrowser”´´½¨ÀýÍâ¡£ÏÂÃæÊǼ¸¸ö¾ßÌåµÄ²Ù×÷·½Ê½£¬Õª×ÔMSDN£¬
¸öÈ˾õµÃÎÄÕµĺÚÌ岿·ÖÓ¦µ±ÌرðµÄÒ»ÆðÎÒÃǵÄ×¢Òâ¡£
ÔÚSQLServer ʵÀýÉÏÆôÓÃÔ¶³ÌÁ¬½Ó
1.Ö¸Ïò“¿ªÊ¼->³ÌÐò->Microsoft SQL Server 2005->ÅäÖù¤¾ß->SQL Server ÍâΧӦÓÃÅäÖÃÆ÷”
2.ÔÚ“SQL Server 2005 ÍâΧӦÓÃÅäÖÃÆ÷”Ò³, µ¥»÷“·þÎñºÍÁ¬½ÓµÄÍâΧӦÓÃÅäÖÃÆ÷”
3.È»ºóµ¥»÷Õ¹¿ª“Êý¾Ý¿âÒýÇ攣¬ Ñ¡ÖГԶ³ÌÁ¬½Ó”£¬ÔÚÓÒ±ßÑ¡ÖГ±¾µØÁ¬½ÓºÍÔ¶³ÌÁ¬½Ó”£¬
ÔÙÑ¡ÔñҪʹÓõÄЭÒ飬( Õâ¸öµØ·½Ó¦µ±ÆôÓÃTCP/IP ºÍÃüÃû¹ÜµÀ·þÎñ£¡)µ¥»÷“Ó¦ÓÔ£¬Äú»á¿´µ½ÏÂÏûÏ¢£º
“Ö±µ½ÖØÐÂÆô¶¯Êý¾Ý¿


Ïà¹ØÎĵµ£º

SQL ʱ¼ä¸ñʽ£¨×ª£©

Select CONVERT(varchar(100), GETDATE(), 0) as 05 16 2006 10:57AM
Select CONVERT(varchar(100), GETDATE(), 1) as 05/16/06
Select CONVERT(varchar(100), GETDATE(), 2) as 06.05.16
Select CONVERT(varchar(100), GETDATE(), 3) as 16/05/06
Select CONVERT(varchar(100), GETDATE(), 4) as 16.05.06
Select CON ......

SQL ServerÐÔÄÜÓÅ»¯µÄһЩ¼¼ÇÉ


Êý¾Ý¿âÐÔÄÜÓÅ»¯Éæ¼°µ½ºÜ¶à·½Ã棬ÔÚÊý¾Ý¿â¿ª·¢Ê±¿ÉÒÔͨ¹ýһЩ»ù±¾µÄÓÅ»¯¼¼ÇÉÌá¸ßÊý¾Ý¿âµÄÐÔÄÜ£º
1£®Ô­ÔòÉÏΪ´´½¨µÄÿ¸ö±í¶¼½¨Á¢Ò»¸öÖ÷¼ü,Ö÷¼üΨһ±êʶijһÐмǼ£¬ÓÃÓÚÇ¿ÖƱíµÄʵÌåÍêÕûÐÔ¡£SQL Server 2005 Database Engine ½«Í¨¹ýΪÖ÷¼üÁд´½¨Î¨Ò»Ë÷ÒýÀ´Ç¿ÖÆÊý¾ÝµÄΨһÐÔ¡£²éѯÖÐʹÓÃÖ÷¼üʱ£¬´ËË÷Òý»¹¿ÉÓÃÀ´¶ÔÊý¾Ý½øÐпì ......

³£ÓÃ+ʵÓõÄSQLÓï¾ä¼¯½õ

ÏÂÁÐÓï¾ä²¿·ÖÊÇMssqlÓï¾ä£¬²»¿ÉÒÔÔÚaccessÖÐʹÓá£
 
SQL·ÖÀࣺ ¡¡¡¡DDL—Êý¾Ý¶¨ÒåÓïÑÔ(CREATE£¬ALTER£¬DROP£¬DECLARE)
DML—Êý¾Ý²Ù×ÝÓïÑÔ(SELECT£¬DELETE£¬UPDATE£¬INSERT)
DCL—Êý¾Ý¿ØÖÆÓïÑÔ(GRANT£¬REVOKE£¬COMMIT£¬ROLLBACK)¡¡¡¡
Ê×ÏÈ,¼òÒª½éÉÜ»ù´¡Óï¾ä£º¡¡¡¡
1¡¢ËµÃ÷£º´´½¨Êý¾Ý¿âCREATE ......

Ôõô°Ñ sqlÓï¾ä²éѯµÄÖµ¸³¸ø±äÁ¿

string str = System.Configuration.ConfigurationManager.AppSettings["strconn"];
string sqlpwd = "select password from bg_user where username='" + username + "'";
MySqlConnection conn = new MySqlConnection(str);
MySqlCommand cmd=new MySqlCommand(sqlpwd,conn);
MySqlDataAdapter adr = new MySqlDataA ......

oracle³£Óþ­µäSQL²éѯ£¨×ªÔØ£©

³£ÓÃSQL²éѯ£º
1¡¢²é¿´±í¿Õ¼äµÄÃû³Æ¼°´óС
select t.tablespace_name, round(sum(bytes/(1024*1024)),0) ts_size
from dba_tablespaces t, dba_data_files d
where t.tablespace_name = d.tablespace_name
group by t.tablespace_name;
2¡¢²é¿´±í¿Õ¼äÎïÀíÎļþµÄÃû³Æ¼°´óС
select tablespace_name, file_id, ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ