.netÁ¬½ÓÊý¾Ý¿â£¬Ö´ÐÐsql½Å±¾
1¡¢¶¨ÒåÖ¸Á£ºusing System.Data.SqlClient;
2¡¢¶¨ÒåsqlÁ¬½Ó£º SqlConnection conn= new SqlConnection("server=(local);database=colorring;uid=sa;pwd=;");
3¡¢´ò¿ªsqlÁ¬½Ó£º conn.Open();
4¡¢¶¨ÒåsqlÓï¾ä£ºstring sqlstr = "insert into test values (123321)";
5¡¢×é×°sqlÓï¾äºÍÁ¬½Ó£ºSqlCommand cmd = new SqlCommand(sqlstr,conn);
6¡¢Ö´ÐÐsqlÃüÁint result=cmd.ExecuteNonQuery();
7¡¢¹Ø±ÕsqlÁ¬½Ó£ºconn.Close();
8¡¢ÏÔʾ¸üеÄÊýÁ¿£º Label1.Text =Convert.ToString(result);
´úÂëÈçÏ£º
using System.Data.SqlClient;
SqlConnection conn= new SqlConnection("server=(local);database=colorring;uid=sa;pwd=;");
conn.Open();
string sqlstr = "insert into test values (123321)";
SqlCommand cmd = new SqlCommand(sqlstr,conn);
int result=cmd.ExecuteNonQuery();
conn.Close();
Label1.Text =Convert.ToString(result);
Ïà¹ØÎĵµ£º
1¡¢ÎļþºÍÎļþ×éµÄº¬ÒåÓë¹Øϵ
ÿ¸öÊý¾Ý¿âÓÐÒ»¸öÖ÷Êý¾ÝÎļþ.ºÍÈô¸É¸ö´ÓÎļþ¡£ÎļþÊÇÊý¾Ý¿âµÄÎïÀíÌåÏÖ¡£ Îļþ×é¿ÉÒÔ°üÀ¨·Ö²¼ÔÚ¶à¸öÂß¼·ÖÇøµÄÎļþ£¬ÊµÏÖ¸ºÔØƽºâ¡£Îļþ×éÔÊÐí¶ÔÎļþ½øÐзÖ×飬ÒÔ±ãÓÚ¹ÜÀíºÍÊý¾ÝµÄ·ÖÅ䣯·ÅÖá£ÀýÈ磬¿ÉÒÔ·Ö±ðÔÚÈý¸öÓ²ÅÌÇý¶¯Æ÷ÉÏ´´½¨Èý¸öÎļþ£¨Data1.ndf¡¢Data2.ndf ºÍ Data3.ndf£©£¬²¢½«ÕâÈý¸ ......
ÔÚÊý¾Ý¿âÖÐÓÐÒ»Õűímytable£¬Êý¾Ý¼Ç¼7000ÍòÌõ£¬ÓÐÈçÏÂÁ½ÌõSQLÓï¾ä
1.
select top 100 * from mytable order by operateDate
2.
select * from (select top 100 * from mytable ) a order by a.operateDate
Æð³õÎÒʹÓõÚÒ»ÌõÓï¾ä²éѯÊý¾Ý£¬²¢Ï£Íû½«µÃµ½µÄ ......
½«Ä³ÖÖÊý¾ÝÀàÐ͵ıí´ïʽÏÔʽת»»ÎªÁíÒ»ÖÖÊý¾ÝÀàÐÍ¡£CAST ºÍ CONVERT ÌṩÏàËƵŦÄÜ¡£
Óï·¨
ʹÓà CAST£º
CAST ( expression AS data_type )
ʹÓà CONVERT£º
CONVERT (data_type[(length)], expression [, style])
²ÎÊý
expression
ÊÇÈκÎÓÐЧµÄ Microsoft® SQL Server™ ±í´ïʽ¡£Óйظü¶àÐÅÏ¢£¬Çë² ......
SQL Server µ¼ÈëºÍµ¼³öÏòµ¼ÌṩÁËÉú³É Microsoft SQL Server 2005 Integration Services (SSIS) °ü×î¼òµ¥µÄ·½·¨¡£SQL Server µ¼ÈëºÍµ¼³öÏòµ¼¿ÉÒÔ·ÃÎʸ÷ÖÖÊý¾ÝÔ´¡£¿ÉÒÔÏòÏÂÁÐÔ´¸´ÖÆÊý¾Ý»ò´ÓÆäÖи´ÖÆÊý¾Ý£º
· Microsoft SQL Server
· ƽÃæÎļþ
· Microsoft Off ......
Ö¢×´£º
SQL SERVER2005ÀïÃ棬Æô¶¯SQL´úÀí·þÎñ£¬Æô¶¯Õý³££¬µ«ÊÇÔÚsql server ´úÀí»¹ÊÇÏÔʾÒѽûÓôúÀí xp
ÔÚManagement StudioÖÐн¨Î¬»¤¼Æ»®Ê±£¬ÌáʾÒÔÏ´íÎóÐÅÏ¢£º
“´úÀíXP”×é¼þÒÑ×÷Ϊ´Ë·þÎñÆ÷°²È«ÅäÖõÄÒ»²¿·Ö±»¹Ø±Õ¡£ÏµÍ³¹ÜÀíÔ±¿ÉÒÔʹÓÃsp_configureÀ´ÆôÓÓ´úÀíXP”¡£ÓйØÆôÓÓ´úÀíXP ......