C#Á¬½ÓSQL Server 2005 ExpressµÄ×Ö·û´®
C#Á¬½ÓSQL ServerµÄSqlConnectionµÄ×Ö·û´®£¬Ðí¶à¶¼ÊDz»ÄÜÁ¬½ÓµÄ¡£ÏÖÔÚ¸øÒ»¸öÄÜÁ¬½ÓµÄ£º
using System.Data.SqlClient;
public class sqlServerConnection {
//
public static void Main() {
//ÏÂÃæ¾ÍÊDZê×¼µÄÁ¬½Ó£¬×¢ÒâSERVERÊÇÎҵļÆËã»úÃû¡£SQLEXPRESSÊÇÊý¾Ý¿âʵÀý¡£SSPI±íʾʹÓÃWindowsµÇ½µÄÕÊ»§¡£masterÊÇÒªÁ¬½ÓµÄÊý¾Ý¿â¡£
//
string cstr = "server=SERVER\\SQLEXPRESS;Initial Catalog=master;Integrated Security=SSPI";
//
try {
//
using (SqlConnection con = new SqlConnection(cstr)) {
con.Open();
System.Console.WriteLine("ServerVersion:{0}",con.ServerVersion);
System.Console.WriteLine("State:{0}",con.State);
}
//
}
catch (System.Exception sqle) {
System.Console.WriteLine(sqle.Message);
}
//
}
//
}
/*
³ÌÐòµÄÊä³ö£º
ServerVersion:09.00.3042
State:Open
*/
//²»Ê¹ÓÃÔ¶³ÌÁ¬½ÓµÄʱºòÓ¦¸Ã°ÑÁ¬½Ó×Ö·û´®¸ÄΪ£º
"Server=localhost\\SQLExpress;Integrated Security=SSPI"
//Ò²¿ÉÒÔÖ¸¶¨Ä¬ÈϵÄÊý¾Ý¿â£¬ÀýÈ磬ָ¶¨Ä¬ÈÏÊý¾Ý¿âÊÇ"master"¾ÍÓ¦¸ÃдΪ£º
"Server=localhost\\SQLExpress;Initial Catalog=master;Integrated Security=SSPI"
»òÕߣº"Server=localhost\\SQLExpress;Initial Catalog=master;Uid=sa;Pwd=sa"
B/SģʽÁ¬½ÓÊý¾Ý¿â£º
string sql="Source=·þÎñÆ÷Ip;database=Êý¾Ý¿âÃû³Æ;UID=sa;Password=sasa;";
C/SģʽÁ¬½ÓÊý¾Ý¿â£º
string sql="Data Source=·þÎñÆ÷Ip;Initial Catalog=Êý¾Ý¿âÃû³Æ;User ID=sa;password=sa";
Á¬½ÓSQL Server 2005 ExpressµÄÎÊÌâ
2010-01-15 13:33
´íÎóÐÅÏ¢£º
“ÔÚ½¨Á¢Óë·þÎñÆ÷µÄÁ¬½Óʱ³ö´í¡£ÔÚÁ¬½Óµ½ SQL Server 2005 ʱ£¬ÔÚĬÈϵÄÉèÖÃÏ SQL Server ²»ÔÊÐí½øÐÐÔ¶³ÌÁ¬½Ó¿ÉÄܻᵼÖ´Ëʧ°Ü¡£ (provider: ÃüÃû¹ÜµÀÌṩ³ÌÐò, error: 40 - ÎÞ·¨´ò¿ªµ½ SQL Server µÄÁ¬½Ó)”
½â¾ö·½°¸£º
1.°²×°Ò»¸öSQL Server Management Studio Express¡£Î¢Èí¹Ù·½ÓÐÏÂÔØ£¬baidu£¬googleÀïÃ涼Äܲ鵽¡£
2.°²×°Íê³Éºó£¬¿ªÊ¼²Ëµ¥ÀïÕÒµ½Microsoft SQL Server 2005--ÅäÖù¤¾ß--SQL Server ÍâΧӦÓÃÅäÖÃÆ÷--·þÎñºÍÁ¬½ÓµÄÍâΧӦÓÃÅäÖÃÆ÷£º
´ò¿ªMSSQLSERVER½ÚµãϵÄDatabase Engine ½Úµã,Ñ¡Ôñ"Ô¶³ÌÁ¬½Ó",ÔÙÑ¡Ôñ"ͬʱʹÓÃTCP/IPºÍNamed pipes",È·¶¨ºóÖØÆôÊý¾Ý¿â·þÎñ¡£
3.ÓÃĬÈÏWindowsÉí·ÝÑé֤ģʽµÇ¼SQL Server Management Studio Express,Ñ¡Ôñ×ó±ßÁбíÀïÃæ
Ïà¹ØÎĵµ£º
ÈçÏÂÁгö²éѯ±í´ïʽ£¬³£ÓòÙ×÷·û£¬ÓëSQLÓï¾ä¶ÔÓ¦¡£
where ¹Ø¼ü×ÖµÄʹÓÃ
public void MyWhere()
{
NorthwindDataContext dc = new NorthwindDataContext();
//²éѯ²úÆ·Ãû³ÆÒÔL¿ªÍ·µÄ¼Ç¼
var query = from p in dc.Products
where p.Prod ......
1. ²é¿´Êý¾Ý¿âµÄ°æ±¾
select @@version
2. ²é¿´Êý¾Ý¿âËùÔÚ»úÆ÷²Ù×÷ϵͳ²ÎÊý
exec master..xp_msver
3. ²é¿´Êý¾Ý¿âÆô¶¯µÄ²ÎÊý
sp_configure
4. ²é¿´Êý¾Ý¿âÆô¶¯Ê±¼ä
select convert(varchar(30),login_time,120) from master ......
mysqlµ¼³ösql½Å±¾ ÊÕ²Ø
×¢ÒâÊÂÏî:
*±ØÐëÔÚD:\LTSOFT\MYSQL4\bin> mysqldump -u root -p test > c:\a.sql
ÏȵýøÈëmysql°²×°Ä¿Â¼µÄbinÏ£¨¿ÉÒÔ¿´µ½ÀïÃæÓÐmysqldump.exe£©£¬Í¨³£mysqlĬÈÏ°²×°ÔÚC:\Program Files\MySQL\MySQL Server 5.0
* ²»ÄܽøÈëmysql ÃüÁîÀï.
MySQLµ¼³ ......
SQL> var a number
SQL> begin
2 :a :=1000;
3 end;
4 /
PL/SQL procedure successfully completed.
SQL> edit
Wrote file afiedt.buf
1 begin
2 dbms_output.put_line(:a);
3* end;
SQL> /
ͨ¹ýÕâ¸ö´úÂë¿ÉÒÔ¿´³öͨ¹ýpl/sql³õʼ»¯¸³ÖµµÄBind variable¿ÉÒÔ±»ÆäËûPl/sql³ÌÐòµ ......
ÎÒÃÇÒª×öµ½²»µ«»áдSQL£¬»¹Òª×öµ½Ð´³öÐÔÄÜÓÅÁ¼µÄSQLÓï¾ä¡£
¡¡¡¡
¡¡¡¡£¨1£©Ñ¡Ôñ×îÓÐЧÂʵıíÃû˳Ðò(Ö»ÔÚ»ùÓÚ¹æÔòµÄÓÅ»¯Æ÷ÖÐÓÐЧ)£º
¡¡¡¡
¡¡¡¡OracleµÄ½âÎöÆ÷°´ÕÕ´ÓÓÒµ½×óµÄ˳Ðò´¦Àífrom×Ó¾äÖеıíÃû£¬from×Ó¾äÖÐдÔÚ×îºóµÄ±í(»ù´¡±í driving table)½«±»×îÏÈ´¦Àí£¬ÔÚfrom×Ó¾äÖаüº¬¶à¸ö±íµÄÇé¿öÏÂ,Äã±ØÐëÑ¡Ôñ ......