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

SQLÊý¾Ý¿âÁ¬½ÓÓï¾ä

Ò»°ãµÄÔ¶³Ì·ÃÎʵÄд³ÉÕâÑù£º
Data Source=IP;Initial Catalog=Êý¾Ý¿âÃû;UserID=Óû§Ãû;Password=ÃÜÂë
±¾µØ·ÃÎʵÄд³ÉÕâÑù£º
Data Source=(local);Initial Catalog=Êý¾Ý¿âÃû;UserID=Óû§Ãû;Password=ÃÜÂë
Èç¹ûÊDZ¾µØµÄ£¬Í¨¹ýwindows×é¼þÑéÖ¤µÄ£¨Ò²¾ÍÊÇûÓÐÓû§Ãû£¬ÃÜÂëµÄ£©Ð´³ÉÕâÑù£º
Data Source=(local);Initial Catalog=Êý¾Ý¿âÃû;Integrated Security=True
Èç¹û²»ÊÇĬÈϵÄʵÀý£¬¼ÙÈçʵÀýÃûÊÇSQLEXPRESS£¬Ð´³ÉÕâÑù£º
Data Source=(local)\SQLEXPRESS;Initial Catalog=Êý¾Ý¿âÃû;Integrated Security=True
ExecuteReader
¼òµ¥¸ßЧµÄ£¬µ¥ÏòǰµÄÊý¾Ý²éѯ¡£·µ»ØÒ»¸öSqlDataReader¶ÔÏó
ͨ³£ÓÃÓÚ¶ÁÈ¡Êý¾Ý
ExecuteNonQuery
·µ»ØÒ»¸öintÀàÐ͵ÄÖµ£¬·µ»ØÊý¾Ý¿âÖÐËùÓ°ÏìµÄÐÐÊý¡£
ÓÃÓÚ¶ÔÊý¾Ý¿âµÄ¸÷ÖÖ²Ù×÷
ExecuteScalar
·µ»Ø¶Á³ö½á¹ûµÄµÚÒ»ÐеÚÒ»ÁÐ
 WorkflowIdled ʼþ
.NET Framework Àà¿â
WorkflowRuntime..::.WorkflowIdled ʼþ
¸üУº2007 Äê 11 ÔÂ
ÔÚ¹¤×÷Á÷ʵÀý½øÈë¿ÕÏÐ״̬ºó·¢Éú
static void Main()
{
    string connectionString = "Initial Catalog=SqlPersistenceService;Data Source=localhost;Integrated Security=SSPI;";
    using (WorkflowRuntime workflowRuntime = new WorkflowRuntime())
    {
        ExternalDataExchangeService dataService = new ExternalDataExchangeService();
        workflowRuntime.AddService(dataService);
        dataService.AddService(expenseService);
        workflowRuntime.AddService(new SqlWorkflowPersistenceService(connectionString));
        workflowRuntime.StartRuntime();
        workflowRuntime.WorkflowCompleted += OnWorkflowCompleted;
        workflowRuntime.WorkflowTerminated += OnWorkflowTerminated;
        workflowRuntime.WorkflowIdled += OnWorkflowIdled;
        workflowRuntime.WorkflowAborted += OnWorkflowAborted;
&


Ïà¹ØÎĵµ£º

һЩ¼òµ¥µÄmysql SQLÓï¾ä±¸Íü

·ÅÔÚÕâÀﱸÍü,ÀÏÊÇÍü¼ÇÔõôд¡£
mysql> create database book;
mysql> use book;
Database changed
mysql> create table email_message(key_mail_messages INTEGER,
-> date_created VARCHAR(19),
-> date_updated varchar(19),
-> date_email varchar(19),
-> addr_from va ......

How to use PL SQL Developer in Ubuntu

You can user PL SQL Developer in Ubuntu like in Windows:
1.download PL/SQL Developer for linux;
2.Install JDK berfore the next;
3.install the PL/SQL Developer;
4.goto the $PL/SQL Developer,run sh sqldeverloper.sh;
5.type the $JDK;
6.then the PL/SQL Developer will startup. ......

ʹÓÃSQLÓï¾ä´´½¨Êý¾Ý¿â


ʹÓÃSQLÓï¾ä´´½¨Êý¾Ý¿â
±¾ÎÄת×Ô£ºhttp://www.cppblog.com/twzheng/archive/2008/07/07/55508.html
      ÓÃCREATE DATABASE´´½¨Êý¾Ý¿âµÄÓï·¨¸ñʽ£º
      CREATE DATABASE database_name   /*Ö¸¶¨Êý¾Ý¿âÃû*/
      [ON× ......

¡¾×ª¡¿´ø´æÔÚÁ¿´ÊNOT EXISTSµÄSQLÓï¾äÎÊÌâ

´ø´æÔÚÁ¿´ÊNOT EXISTSµÄSQLÓï¾äÎÊÌâ
ѧÉú±ístudent (snoѧºÅ snameÐÕÃû sdeptËùÔÚϵ)
¿Î³Ì±ícourse (cno¿Î³ÌºÅ cname¿Î³ÌÃû cpnoÑ¡Ð޿κŠccreditѧ·Ö)
ѧÉúÑ¡¿Î±ísc (sn0ѧºÅ cno¿Î³ÌºÅ grade³É¼¨)
¶ÔÒÔÉÏ±í½øÐвéѰѡÐÞÁËÈ«²¿¿Î³ÌµÄѧÉúÐÕÃû
ÓÉÓÚ²»£¬Ã»ÓÐÈ«³ÆÁ¿´Ê£¬¿É½«ÌâÄ¿µÄÒâ˼ת»»ÎªµÈ¼ÛµÄ´æÔÚÁ¿´ÊÐÎʽ£º²éÑ ......

SQL 2008 Çå³ýÈÕÖ¾Îļþ

ÓÒ»÷ÒªÇå³ýÈÕÖ¾µÄÊý¾Ý¿â Ñ¡ÔñÊôÐÔ 
  
ÔÚÊý¾Ý¿âÊôÐÔÖÐ Ñ¡ÔñÑ¡Ïî ÔÚÓұ߻ָ´Ä£Ê½ÏÂÀ­Áбí¿òÖÐ Ñ¡Ôñ¼òµ¥ µ¥»÷È·¶¨ ·µ»Ø 
  
ÓÒ»÷ÒªÇå³ýÈÕÖ¾µÄÊý¾Ý¿â Ñ¡ÔñÈÎÎñ-ÊÕËõ-Êý¾Ý¿â µ¥»÷È·¶¨ 
  
Íê³ÉÊÕËõ ÈÕÖ¾Îļþ´óС±äΪ0  ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ