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

sqlÔõÑù²åÈëÊý¾Ý°¡

ºÃÆæ¹Ö£¬ÎÒÔÚÎҵĵçÄÔÉÏ×÷µÄÒ»¸ö¼òµ¥µÄÁôÑ԰壬ÁôÑԳɹ¦£¬Ò»ÇÐÕý³££¬ÓÚÊÇÎҾͰÑËüŪµ½·þÎñÆ÷ÉÏÈ¥£¬½á¹ûʲôÏÖÏó¶¼Ã»ÓУ¬²»¹ÜÓò»Óô洢¹ý³ÌÔÚÎÒµçÄÔÉ϶¼ÕýÈ·¶ø·þÎñÆ÷×ÜÊÇûÓз´Ó¦
ConnectionStringSettings setting = System.Configuration.ConfigurationManager.ConnectionStrings["masterConnectionString"];
        SqlConnection conn = new SqlConnection(setting.ConnectionString);
        conn.Open();
        SqlCommand cmd = new SqlCommand("insert into talk (text) values (@text)", conn);
        //cmd.CommandType = CommandType.StoredProcedure;
        cmd.Parameters.Add("@text", SqlDbType.NVarChar);
        cmd.Parameters["@text"].Value = this.content1.Value;
        cmd.ExecuteNonQuery();
        conn.Close();
        this.content1.Value = "";

¾ÍÁ¬×îºóÒ»¾äthis.content1.Value = "";Çå¿ÕÁôÑÔ¿ò¶¼²»Ö´ÐÐÁË£¬²»±¨´í£¬

´ÓÎҵIJâÊÔÊý¾Ý¿´£¬Á¬½ÓÒ²¾ÍûÎÊÌâÁË£¬¾ÍÈçÕâ¸ö»­ÃæÒ»Ñù£¬ÎÒµãÁË È·ÈÏÁôÑÔ  ºó£¬»¹ÊÇÕ⸱»­Ãæ
Connection StringÊÇ·ñÕýÈ·ÄØ£¿

´ÓÄãµÄÃèÊö¿´¿ÉÄÜÕâ¸ö¹ý³ÌûÓÐÖ´ÐÐ,µ¥²½¸ú×Ù¿´ÏÂ

file:///C:/Documents%20and%20Settings/Administrator/×ÀÃæ/QQ½ØÍ¼Î´ÃüÃû.jpg


Ó¦¸ÃÊÇÄãµÄÁ¬½Ó×Ö·û²»¶ÔÁË£¬µ¥²½¸ú×ÙÏÂ

¶÷£¬Í¬Òâ4Â¥µÄ¿´·¨
Ó¦¸Ã¼ì


Ïà¹ØÎÊ´ð£º

ÃÅÍ⺺ÇóÖú...¹ØÓÚºǫ́+SQL+ASP

....½Óµ½Ò»¸öС³ÌÐò..¹¤×÷Ô­À´´ó¸ÅÊÇÕâÑùµÄ...ǰ̨ÊÇWEB·þÎñÆ÷.¼Ü¹¹¾ÍÊÇASP+SQL..ǰ̨ÓÉASPÏòSQLÌí¼Ó·þÎñÀà±ð(±íµ¥).È»ºóÓÖºǫ́³ÌÐò¶ÁÈ¡±íµ¥..Ҫʵʱ¶ÁÈ¡..È»ºóÏÔʾÔÚ·þÎñÆ÷ÉÏÃæ..´ÓÀíÂÛÉÏÃæÄÜÐÐͨ²»?Èç¹û¿ÉÒÔ..ºǫ́ ......

ÇóSQL£¿

´ó¼ÒºÃ£¬ÇëÎÊÔÚ±íMÖÐÓÐ×ֶΣºa b c d e 
ÎÒÏë²é³öÆäÖÐÂú×ãÏÂÃæÈÎÒâÒ»ÏîµÄÊý¾Ý£¬1.×Ö¶Îa µÄÖµ²»ÊÇ ¡®Êé»ò±Ê»ò±¾¡¯ÖÐÈÎÒ»£¬2.aΪÊéµÄʱºò×Ö¶Îb,cÊÇ¿Õ;3.µ±aֵΪ±ÊµÄʱºòdÊÇ¿Õ;4.µ±aΪ±¾µÄʱºòb,d,e¶¼ÊÇ¿Õ;5.È ......

Á½¸öµ¼¹¹sql serverÊý¾Ý¿â,Êý¾Ýµ¼Èëµ¼³öÎÊÌâ

ÏÖÔÚÓÐÁ½¸öÒì¹¹µÄsql serverÊý¾Ý¿â,ÎÒÏ뽫µÚÒ»¸ö±íÖеÄÊý¾Ýµ¼Èëµ½µÚ¶þ¸ö±íÖÐ,×Ô¼ºÖ¸¶¨µ¼ÈëÊý¾ÝµÄ×Ö¶Î,ÈçºÎµ¼ÈëÊý¾ÝÄØ,´ó¼ÒÌÖÂÛÒ»ÏÂ?
dts¹¤¾ß

µ¼Èëµ¼³ö¹¤¾ß.

DD

¹þ¹þ£¬¹À¼ÆÕâλÊǵØQIOU¶¼Êܲ»Á˵Ä

Ö±½ÓÐ ......

pl/sqlµ¼ÈëÊý¾ÝÎÊÌâ

ÎÒEXCELÖÐÒ»¸öµ¥Ôª¸ñµÄÊý¾ÝÈç  "2009-01","8949-232"

½«Õâ¸öÊý¾ÝÕ³Ìùµ½PL/SQLÖеÄÒ»¸ö±íÖкó,Êý¾ÝÈ·ÊdzÉΪÁË 2009-01,8949-232 ,°ÑËùÓеÄ""¶¼Ã»ÁË,
ÈçºÎÅªÄØ?Çë´ó¼ÒÊÔ ......

SQLÓï¾äЧÂÊÎÊÌâ - ÆäËûÊý¾Ý¿â¿ª·¢ / ÆäËûÊý¾Ý¿â

´ó¼Ò°ïæ¿´¿´Õâ2¸ösqlÓï¾äÄĸö²éѯµÄËٶȸü¿ìµã¡£Ð»Ð»°ïæ¡£±È½Ï׿±¡£ÔÚ×öÐÔÄܲâÊÔ¡£
select * from
  ±íA LEFT OUTER JOIN ±íB ON (±íA.id || ' ' =±íB.id) ,±íC , ±íD, ±íE
WhereÆäËûÌõ¼þ
select * ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ