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

linq to sql ÖеÄÀàÐÍÇ¿´«½â¾ö·½°¸

 List<Class1> li = dc.Table_1.Where(item => item.id > 1).Cast<Class1>().ToList();
Table_1 Ϊ×Ô¶¯Éú³ÉÀà, class1Ϊ×Ô¶¨ÒåÀà,ÊôÐÔÃû³Æ¶¼ÊÇÒ»ÑùµÄ,ÒªÄÜʵÏÖÉÏÃæµÄÓï¾ä,±ØÐëÓм¸¸öÌõ¼þ
Table_1 ÐèÒª¼Ì³Ðclass1,¿ÉÒÔͨ¹ýpartialÀàÀ´ÊµÏÖ
Table_1  ÊôÐÔ¼Óoverride
class1ÀïÃæµÄÊôÐÔÒªÊÇvirtual »òÆäËü¿É¼Ì³ÐÐÞÊηû


Ïà¹ØÎĵµ£º

µ¼³öÊý¾Ý¡¢Éú³ÉSQL INSERTµÄ·½·¨¡£

ÔÚ¹¤×÷Öг£³£Åöµ½ÕâÖÖÇé¿ö£ºÎÒÃÇÐèÒª½«Ò»¸öÓ¦ÓÃϵͳµÄ»ù´¡Êý¾Ýµ¼³öÀ´£¬ÒÔ±ã»ù´¡Êý¾ÝÏ´ε¼Èëµ½ÁíÍâÒ»¸ö³¡¾°¡£
ÊÂʵÉÏ£¬ÕâÖÖÇé¿öÎÒÃÇ¿ÉÒÔÓÃpl/sqlµÄ¹¦ÄÜExport TablesÀ´ÊµÏÖ¡£Export TableÓÐÈýÖÖµ¼³ö·½Ê½£ºOracle Export£¬SQL Insert£¬PL/SQL Developer¡£Í¨³£ÎÒÃÇ»áʹÓÃOracle Export£¬SQL InsertµÄ¹¦ÄÜ¡£(µÚÈýÖÖ°³Ã»Óùý£¬ ......

sqlÖÐÈÕÆÚ¸ñʽ

1 ---ÉϸöÔÂÔ³õµÚÒ»Ìì
  2  select CONVERT(varchar(12) , DATEADD(mm,DATEDIFF(mm,0,dateadd(mm,-1,getdate())),0), 112 )
  3
  4  ---ÉϸöÔÂÔÂÄ©×îºóÒ»Ìì
  5  select CONVERT(varchar(12),dateadd(ms,-3,DATEADD(mm,DATEDIFF(m,0,getdate()),0)), 112 )
  6
  7 ......

ÖØÐÂÉ趨sql serverÊý¾Ý¿âµÄÓ²Å̱¸·ÝµØÖ·

дÁËÒ»¸öС³ÌÐò£¬Ê¹ÓÃÁËsql server 2005Êý¾Ý¿â£¬µ±Ê±¸ÃÊý¾Ý¿â·Åµ½ÁËC:\Program Files\Microsoft SQL Server\MSSQL.4\MSSQL\DataÏÂÃæ£¬µ«ÊÇÏÖÔÚ¾õµÃ²»·½±ã£¬Ïë°ÑËü×ªÒÆµ½ÎÒÕâ¸öÍøÕ¾´úÂëËùÔÚµÄÄǸöĿ¼£¬±ÈÈçd£º\network\app_dataÏÂÃæ£¬ÇëÎÊÔõôת¹ýÈ¥£¬Ð»Ð»£¿
»¹ÓÐÒ»¸öÎÊÌ⣬¾ÍÊÇÎÒ¿´C:\Program Files\Microsoft SQL Serve ......

SybaseµÄSQL Anywhere for BlackBerry

UltraLite®J£ºBlackBerryÉÏÔËÐеÄСÊý¾Ý¿âºÍͬ²½ÒýÇæ
MobiLink £ºÔËÐÐÔÚ·þÎñÆ÷ÉÏÊý¾Ý¿âͬ²½·þÎñÆ÷£¬¿ÉÒÔ°ÑÉ豸ÉϵÄÊý¾Ýͬ²½µ½ºǫ́µÄ¡£°üº¬ÔÚSQL Anywhere 11ÀïÃæ¡£
SQL Anywhere ÊÇÒµÄÚÁìÏȵÄÒÆ¶¯ºÍǶÈëʽÊý¾Ý¿â£¬ÌṩÊý¾Ý¹ÜÀíºÍ½»»»¼¼Êõ£¬ÎªÒ»Ïß»·¾³ÖеÄÓ¦ÓóÌÐòÌṩ֧³Ö¡£
SQL Anywhere רΪ²»¾ß±¸ÏÖ³¡ IT Ö§³Ö¡¢Ô ......

SQL Server CE·þÎñÆ÷¶ËºÍ¿Í»§¶Ë°²×°ÅäÖÃѧϰ±Ê¼Ç

 
SQL Server 2005 CE¿ª·¢»·¾³½éÉÜ£º
       ×î½üѧϰʹÓÃSQL Server 2005 Compact Edition½øÐÐÊý¾Ý´æ´¢£¬ÔÚѧϰµÄ¹ý³ÌÖз¢ÏÖ£¬Ê¹ÓÃSQL Server2005 management Studio´´½¨Êý¾Ý¿âʱ£¬ÔÚ“·þÎñÆ÷ÀàÐÍ”ÏÂÀ­ÁбíÖÐûÓГSQL Server Compact Edition”Ñ¡Ïî¡£ÒòΪÎÄÕ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ