SQLÓï¾ä²éѯÊÇ·ñΪ¿Õ =null¼°null
a b c d
980515 ¾«頂Æó業ÓÐÏÞ¹«Ë¾ 簡¼ÒºÀ NULL
980514 È«ÐÀľ業ÓÐÏÞ¹«Ë¾ NULL 123
980514 Ѹ億¿Æ¼¼¹É·ÝÓÐÏÞ¹«Ë¾ 簡·ê¿£ NULL
980515 聖Ô½國際Æó業ÓÐÏÞ¹«Ë¾ NULL 111
±í½á¹¹ÈçÉÏËùʾ£¬Òª²éѯCÁÐΪ¿ÕµÄ¼Ç¼µÄ£Ó£Ñ£ÌÓï¾ä²»ÊÇselect * from table where c=null; »òÕß select * from table where c=’’; ¶øÓ¦µ±ÊÇ select * from table where c is null; Ïà·´µØÒª²éѯ²»Îª¿ÕµÄÔòÓ¦µ±ÊÇ select * from talbe where c<>’’; »òÕß select * from table where c is not null; ×¢Ò⣺²»ÊÇnot is nullŶ¡£
Ïà¹ØÎĵµ£º
JOINÓÅ»¯
MySQLÖÐjoinµÄʵÏÖ²ÉÓõÄÊÇNested Loop JoinËã·¨¡£Í¨¹ýÇý¶¯±íµÄ½á¹û¼¯×÷Ϊѻ·»ù´¡Êý¾Ý£¬È»ºó½«¸Ã½á¹û¼¯ÖеÄÊý¾Ý×÷Ϊ¹ýÂË
Ìõ¼þÒ»ÌõÌõµÄµ½ÏÂÒ»¸ö±íÖвéѯÊý¾Ý£¬×îºóºÏ²¢½á¹û£¬Èç¹û´æÔÚºóÐø±í£¬¹ý³ÌÒ²Èç´Ë¡£
¾¡Á¿¼õÉÙjoinÓï¾äÖÐnested loopÑ»·µÄ´ÎÊý¡£×îÓÐЧµÄ·½·¨ÊÇÈÃÇý¶¯±íµÄ½á¹û¼¯¾¡¿ÉÄܵÄС
ÓÅÏÈÓÅ»¯nested ......
½«Ä³ÖÖÊý¾ÝÀàÐ͵ıí´ïʽÏÔʽת»»ÎªÁíÒ»ÖÖÊý¾ÝÀàÐÍ¡£CAST ºÍ CONVERT ÌṩÏàËƵŦÄÜ¡£
Óï·¨
ʹÓà CAST£º
CAST ( expression AS data_type )
ʹÓà CONVERT£º
CONVERT (data_type[(length)], expression [, style])
²ÎÊý
expression
ÊÇÈκÎÓÐЧµÄ Microsoft® SQL Server™ ±í´ïʽ¡£Óйظü¶àÐÅÏ¢£¬Çë² ......
SQL Server µ¼ÈëºÍµ¼³öÏòµ¼ÌṩÁËÉú³É Microsoft SQL Server 2005 Integration Services (SSIS) °ü×î¼òµ¥µÄ·½·¨¡£SQL Server µ¼ÈëºÍµ¼³öÏòµ¼¿ÉÒÔ·ÃÎʸ÷ÖÖÊý¾ÝÔ´¡£¿ÉÒÔÏòÏÂÁÐÔ´¸´ÖÆÊý¾Ý»ò´ÓÆäÖи´ÖÆÊý¾Ý£º
· Microsoft SQL Server
· ƽÃæÎļþ
· Microsoft Off ......
1¡¢¶¨ÒåÖ¸Á£ºusing System.Data.SqlClient;
2¡¢¶¨ÒåsqlÁ¬½Ó£º SqlConnection conn= new SqlConnection("server=(local);database=colorring;uid=sa;pwd=;");
3¡¢´ò¿ªsqlÁ¬½Ó£º conn.Open();
4¡¢¶¨ÒåsqlÓï¾ä£ºstring sqlstr = "insert into test values (123321)";
5¡¢×é×°sqlÓï¾äºÍÁ¬½Ó£ºSqlCommand cmd = new SqlCo ......
http://inthirties.com:90/thread-1202-1-1.html
Ç°ÃæÎÄÕ ”v$sql,v$sqlarea,v$sqltextÓÐʲôÇø±ð“ ¼û http://blog.csdn.net/inthirties/archive/2010/03/10/5364777.aspx
ÕâÀï²¹³äÒ»ÏÂ
²¹³ä£º
1¡¢²éÒ»ÏÂÕâЩÊÓͼµÄ¶¨ÒåÄã¾ÍÄÜÀí½â£¬ËüÃǵÄÔ´¶¼ÊÇÒ»¸ö¡£
SELECT view_definition from v$fixed_view_definiti ......