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

ÕýÊÔ½øÈëlinq to sqlѧϰ

¶àÓàµÄ»°¾Í²»¶à˵ÁË£¬ÕýÊÔlinq to sqlµÄѧϰ¡£
ÏÈÀ´¿´¿´linq to sql µÄÌØÐÔ:
×Ô¶¯ÊôÐÔ(Auto-Implemented Properties)
Òþº¬ÀàÐ;ֲ¿±äÁ¿(Local Variable Type Inference)
ÄäÃûÀàÐÍ(Anonymous Types)
¶ÔÏóÓ뼯ºÏ³õʼ»¯Æ÷(Object and Collection Initializers)
À©Õ¹·½·¨(Extension Methods)
Lambda±í´ïʽºÍLambda±í´ïʽÊ÷ (Lambda Expression and Lambda Expression Trees)
×Ô¶¯ÊôÐÔ(Auto-Implemented Properties)
×Ô¶¯ÊôÐÔ¿ÉÒÔ±ÜÃâÔ­À´ÕâÑùÎÒÃÇÊÖ¹¤ÉùÃ÷Ò»¸ö˽ÓгÉÔ±±äÁ¿ÒÔ¼°±àдget/setÂß¼­£¬ÔÚVS2008ÖпÉÒÔÏñÏÂÃæÕâÑù±àдһ¸öÀ࣬±àÒëÆ÷»á×Ô¶¯µØÉú³É˽ÓбäÁ¿ºÍĬÈϵÄget/set ²Ù×÷¡£ÄãÒ²¿ÉÒÔ·Ö±ð¶¨ÒågetºÍsetµÄ“protected”µÈ·ÃÎʼ¶±ð¡£
ÔÚ.Net2.0¿ò¼ÜÏ£¬ÎÒÃÇ¿ÉÒÔÕâÑùдһ¸öUserÀࣺ
public class User
{
private int _id;
private string _name;
private int _age;
public int Id
{
get { return _id; }
set { _id = value; }
}
public string Name
{
get { return _name; }
set { _name = value; }
}
public int Age
{
get { return _age; }
set { _age = value; }
}
}
ÏÖÔÚ£¬¿ÉÒÔÕâÑù¼ò»¯£º
public class User
{
public int Id { get; set; }
public string Name { get; set; }
public int Age { get; set; }
}


Ïà¹ØÎĵµ£º

²é¿´Oracle±í¿Õ¼äʹÓÃÇé¿öSQLÓï¾ä

 select f.tablespace_name,a.total,u.used,f.free,round((u.used/a.total)*100) "% used", round((f.free/a.total)*100) "% Free"
from
(select tablespace_name, sum(bytes/(1024*1024)) total
from dba_data_files group by tablespace_name) a,
(select tabl ......

Oracle PL/SQL±à³Ì¹æ·¶Ö¸ÄÏ

Ò»¡¢PL/SQL±à³Ì¹æ·¶Ö®´óСд
¾ÍÏñÔÚSQLÖÐÒ»Ñù£¬PL / SQLÖÐÊDz»Çø·Ö´óСдµÄ¡£ÆäÒ»°ã×¼ÔòÈçÏ£º
¹Ø¼ü×Ö(BEGIN, EXCEPTION, END, IF THEN ELSE,LOOP, END LOOP)¡¢Êý¾ÝÀàÐÍ(VARCHAR2, NUMBER)¡¢ÄÚ²¿º¯Êý(LEAST, SUBSTR)ºÍÓû§¶¨ÒåµÄ×Ó³ÌÐò(procedures, functions,packages)£¬Ê¹Óôóд¡£
±äÁ¿ÃûÒÔ¼°SQLÖеÄÁÐÃûºÍ±íÃû£¬Ê¹ÓÃÐ ......

³£ÓÃSQLÓï¾ä£¨Oracle£©(ת)

ORACLEÖÐ×ֶεÄÊý¾ÝÀàÐÍ
   ×Ö·ûÐÍ    char        ·¶Î§  ×î´ó2000¸ö×Ö½Ú ¶¨³¤
               char(10)   'ÕÅÈý' ºóÌí¿Õ¸ñ6¸ö°Ñ10¸ö×Ö½Ú²¹Âú  'ÕÅÈý &nb ......

PL/SQLѧϰ±Ê¼Ç


1£®SQL²¢Ðвéѯ
alter session enable parallel dml execute immediate 'alter session enable parallel dml'; --Ð޸ĻỰ²¢ÐÐDML      select /*+parallel(a,4)*/ * from table_name a       select /*+parallel(a,8)*/ * from table_name a    ......

SQL Server 2000°²×°Öظ´³öÏÖ¹ÒÆðÎÊÌâ½â¾ö°ì·¨

  ½ñÌì°²×°sql server2000.ϵͳÊÇXP professional¡£Ê×ÏÈÏȰ²×°sqlserverÆóÒµ°æµÄ£¬Ö»Äܰ²×°¿Í»§¶Ë£»È»ºó°²×°sqlserver¿ª·¢°æ£¬¾Í ±»¹ÒÆð£¬Òò´ËÍøÉÏËÑÂÞÏà¹ØÐÅÏ¢¡£
1¡¢ Èô³öÏÖ¹ÒÆðºó£¬¿É°´ÏÂÁвÙ×÷½øÐУ¬±¾ÈËÒѾ­ÊÔÓùý£º
      ÔÚÔËÐд°¿ÚÊäÈëregedit£¬´ò¿ª×¢²á±í±à¼­Æ÷£¬ÔÚHKEY_LOCA ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ