LINQ to SQL ѧϰreference
http://weblogs.asp.net/scottgu/archive/2007/09/07/linq-to-sql-part-9-using-a-custom-linq-expression-with-the-lt-asp-linqdatasource-gt-control.aspx
1-9 parts are the most useful knowledge for you so far.
Ïà¹ØÎĵµ£º
mysql¿ÉÒÔÔËÐÐÔÚ²»Í¬sql modeģʽÏÂÃæ£¬sql modeģʽ¶¨ÒåÁËmysqlÓ¦¸ÃÖ§³ÖµÄsqlÓï·¨£¬Êý¾ÝУÑéµÈ£¡
²é¿´Ä¬ÈϵÄsql modeģʽ£º
select @@sql_mode;
ÎÒµÄÊý¾Ý¿âÊÇ£º
STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION
ÔÚ´ËģʽÏÂÃæ£¬Èç¹û²åÈëµÄÊý¾ÝµÄ³¤¶È´óÓÚ¶¨ÒåµÄ³¤¶È£¬ÄÇô¾Í»á±¨´í£¡
......
±ê׼˳ÐòµÄ SQL Óï¾äΪ:
Select ¿¼ÉúÐÕÃû, max(×ܳɼ¨) as max×ܳɼ¨
from tb_Grade
where ¿¼ÉúÐÕÃû is not null
group by ¿¼ÉúÐÕÃû
having max(×ܳɼ¨) > 600
order by max×ܳɼ¨
ÔÚÉÏÃæµÄʾÀýÖÐ SQL Óï¾äµÄÖ´ÐÐ˳ÐòÈçÏÂ:
(1). Ê×ÏÈÖ´ÐÐ from ×Ó¾ä, ´Ó tb_G ......
1.oracle
sql = "SELECT column_name, data_type, data_length, nullable";
sql += " from user_tab_columns ";
sql += " where table_name='";
sql += $tableName;
sql += "'";
select * from user_tab_comments & ......
ÍøÕ¾£ºhttp://werysoft.com/
Èç¹ûÄú±ØÐë¹ÜÀí»·¾³ÖеĶàÖÖÀàÐ͵ÄÊý¾Ý¿â·þÎñÆ÷£¬ÔòʹÓü¯ÖÐʽ¹¤¾ßµ÷ÕûËùÓÐÊý¾Ý¿â¿ÉÄÜ»á±È½Ï·½±ã¡£Werysoft µÄ QweryBuilder Ö¼ÔÚΪÄúÌṩ´ËÏÄÜ¡£Äú¿ÉÒÔʹÓÃËü´Óͬһ GUI Á¬½Óµ½ Microsoft SQL Server¡¢Sybase ASE¡¢SQL Anywhere ºÍ Oracle ʵÀý£¬È»ºó²é¿´¡¢´´½¨¡¢¸üкÍɾ³ýÊý¾Ý¿â½Å±¾¡¢¼Ü ......