Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö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Â¥µÄ¿´·¨
Ó¦¸Ã¼ì


Ïà¹ØÎÊ´ð£º

ÈçºÎÓÃc#£¬sql2000 ¿ª·¢c/sÏµĹ¤×÷Á÷£¿

±¾ÈËc#ÐÂÊÖ ¿ÉÊÇÒªÇóÒªÓÃc# £¬sql2000¿ª·¢c/sµÄ¹¤×÷Á÷£¬Ò»Í·ÎíË®£¬Çë´ó¼Ò°ïæ°ï棬¸øµã˼·£¬ËµµÄÔ¼¾ßÌåÔ½ºÃ£¬ÎÒÒ²ºÃÍùÄǸö·½ÃæÈ¥Ñ§Ï°
http://www.hxzi.com/view/61402.html
B/S°æµÄ£¬»ù±¾Ë¼ÏëÓ¦¸Ã²î²»¶àµÄ¡£¡£ ......

sql server ´æ´¢¹ý³ÌÑ­»·¸³ÖµµÄÎÊÌâ

СµÜÊǸöÐÂÊÖ ÏÖÔÚÓиöÎÊÌâÒ»Ö±²»Äܽâ¾ö
ÀýÈç
procedure produce_proc
    @p001 nvarchar(8000),
    @p002 nvarchar(8000),
    @p003 nvarchar(8000),
  & ......

SQLÓï¾äÎÊÌ⣬¸ßÊÖ°ïæ£¡£¡

½«Ò»¸ö±í21~30ɾ³ý£¬sqlÓï¾äÔõôд
Õâ¸öÌ«ÁýͳÁË£¬ÊÇÅÅÐòºóµÄµÚ21Ìõµ½30Ìõ¼Ç¼ɾ³ý»¹ÊÇijһÁÐÖµÔÚ21µ½30Ö®¼äµÄɾ³ý°¡£¿

21-30ÊÇʲôÒâ˼£¿×ֶεϰ¾Ídelete from table1 where col1>=21 and col1<=30
Ö¸µ ......

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

´ó¼Ò°ïæ¿´¿´Õâ2¸ösqlÓï¾äÄĸö²éѯµÄËٶȸü¿ìµã¡£Ð»Ð»°ïæ¡£±È½Ï׿±¡£ÔÚ×öÐÔÄܲâÊÔ¡£
select * from
  ±íA LEFT OUTER JOIN ±íB ON (±íA.id || ' ' =±íB.id) ,±íC , ±íD, ±íE
WhereÆäËûÌõ¼þ
select * ......

Çë½ÌÒ»¸öSQL²éѯ

ÓÐÈçÏÂÁ½¸ö±í
tb1
col  col1
abc  111 
cde  111 
qaz  222   
tgb  222

tb2
col2  col3
abc    111&n ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ