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

Èí¼þ²âÊÔÖг£ÓõÄSQLÓï¾ä

²éѯÓï¾ä
Óï·¨¸ñʽ£º
SELECT
    [ALL | DISTINCT | DISTINCTROW ]
      [HIGH_PRIORITY]
      [STRAIGHT_JOIN]
      [SQL_SMALL_RESULT] [SQL_BIG_RESULT] [SQL_
      [SQL_CACHE | SQL_NO_CACHE] [SQL_CALC_FOUN
    select_expr [, select_expr ...]
    [from table_references
    [WHERE where_condition]
    [GROUP BY {col_name | expr | position}
      [ASC | DESC], ... [WITH ROLLUP]]
    [HAVING where_condition]
    [ORDER BY {col_name | expr | position}
      [ASC | DESC], ...]
    [LIMIT {[offset,] row_count | row_count OFF
    [PROCEDURE procedure_name(argument_list)]
    [INTO OUTFILE 'file_name' export_options
      | INTO DUMPFILE 'file_name'
      | INTO var_name [, var_name]]
[FOR UPDATE | LOCK IN SHARE MODE]]
³£ÓþÙÀý
--²éѯmember±íÖÐËùÓеĻáÔ±¼Ç¼
SELECT * from member;
ÆäÖГ*”ºÅ±íʾÏÔʾ·ûºÏÌõ¼þµÄ¼Ç¼µÄËùÓÐ×Ö¶Î
ÔÚÊý¾Ý¿âÖд洢ÀàÐÍΪÎı¾µÄ×ֶβéѯ
--²éѯmember±íÖÐÐÕÃû½ÐÕÅÈýµÄ»áÔ±
SELECT * from member WHERE name = 'ÕÅÈý';
--²éѯmember±íÖÐËùÓÐÐÕÕŵĻáÔ±
SELECT * from member WHERE name like ‘ÕÅ%’;
ÆäÖГ%”±íʾÈÎÒâ×Ö·û¶¼·ûºÏÌõ¼þ¡£¼´Ö»ÓÐÂú×ãÐÕÃûÖеÚ1¸ö×Ö·ûÊÇ“ÕÅ”¾ÍÂú×ã²éѯÌõ¼þ
--²éѯmember±íÖÐËùÓÐÃû×Ö°üº¬“Èý”µÄ»áÔ±
SELECT * from member WHERE name like ‘%Èý%’;
ÓÉÓÚ“Èý”×Öǰºó¶¼º¬Óаٷֺœ%”£¬Õâ¾Í±íʾ“Èý”×ÖÇ°ÃæºÍ“Èý”×ÖºóÃæ²»¹ÜÊÇÈκÎ×Ö·û¶¼Âú×ã²éѯÌõ¼þ£¬¼´Ê¹“Èý”×ÖǰºóûÓÐ×Ö·ûÒ²·ûºÏÌõ¼þ
ÔÚÊý¾Ý¿âÖÐÄêÁä´æ´¢ÎªÊý×ÖÀàÐ͵Ä×ֶβéѯ
--²éѯmember±íÖÐÄêÁäµÈÓÚ18µÄ»áÔ±
SELECT * from member WHERE age = 18;
--²éѯmember±íÖÐÄêÁä´óÓÚµÈÓÚ18µÄ»áÔ±
SELECT * from member WHERE age >= 18;


Ïà¹ØÎĵµ£º

sql 2005 ´æ´¢¹ý³Ì·ÖÒ³ java ´úÂë

 create PROCEDURE pagelist
@tablename nvarchar(50),
@fieldname nvarchar(50)='*',         
@pagesize int output,--ÿҳÏÔʾ¼Ç¼ÌõÊý
@currentpage int output,--µÚ¼¸Ò³
@orderid nvarchar(50),--Ö÷¼üÅÅÐò
@sort int,--ÅÅÐò·½Ê½£¬1±íʾÉýÐò£¬0±íʾ½µÐòÅÅÁÐ ......

SQL Server 2000Êý¾Ý¿âÖÃÒɵĽâ¾ö·½·¨

 Ê×ÏÈ£º·ÖÀëÊý¾Ý¿â
ÆóÒµ¹ÜÀíÆ÷--ÓÒ¼üsuspectµÄÊý¾Ý¿â--ËùÓÐÈÎÎñ--·ÖÀëÊý¾Ý¿âÈ»ºó±¸·ÝÄãµÄsuspectÊý¾Ý¿âµÄÎļþ,ÔÙ°´ÏÂÃæµÄ²½Öè´¦Àí:
1.н¨Ò»¸öͬÃûµÄÊý¾Ý¿â
2.ÔÙÍ£µôsql server
3.ÓÃsuspectÊý¾Ý¿âµÄÎļþ¸²¸ÇµôÕâ¸öн¨µÄͬÃûÊý¾Ý¿â
4.ÔÙÖØÆôsql server
5.´Ëʱ´ò¿ªÆóÒµ¹ÜÀíÆ÷ʱн¨µÄͬÃûÊý¾Ý¿â»á³öÏÖÖÃÒÉ£¬ÏȲ» ......

liq to sql union

Union All/Union/Intersect²Ù×÷
ÊÊÓó¡¾°£º¶ÔÁ½¸ö¼¯ºÏµÄ´¦Àí£¬ÀýÈç×·¼Ó¡¢ºÏ²¢¡¢È¡ÏàͬÏî¡¢ÏཻÏîµÈµÈ¡£
Concat£¨Á¬½Ó£©
˵Ã÷£ºÁ¬½Ó²»Í¬µÄ¼¯ºÏ£¬²»»á×Ô¶¯¹ýÂËÏàͬÏÑÓ³Ù¡£
1.¼òµ¥ÐÎʽ£º
var q = (
from c in db.Customers
select c.Phone
).Concat(
from c in db.Customers
......

oralce sqlÓÅ»¯34Ìõ

ÎÒÃÇÒª×öµ½²»µ«»áдSQL,»¹Òª×öµ½Ð´³öÐÔÄÜÓÅÁ¼µÄSQL,ÒÔÏÂΪ±ÊÕßѧϰ¡¢ÕªÂ¼¡¢²¢»ã×ܲ¿·Ö×ÊÁÏÓë´ó¼Ò·ÖÏí£¡
£¨1£©      Ñ¡Ôñ×îÓÐЧÂʵıíÃû˳Ðò(Ö»ÔÚ»ùÓÚ¹æÔòµÄÓÅ»¯Æ÷ÖÐÓÐЧ)£º
ORACLE µÄ½âÎöÆ÷°´ÕÕ´ÓÓÒµ½×óµÄ˳Ðò´¦Àífrom×Ó¾äÖеıíÃû£¬from×Ó¾äÖÐдÔÚ×îºóµÄ±í(»ù´¡±í driving table)½«±»×îÏÈ´¦Àí£¬ÔÚfrom× ......

SQL begin end ¿é×÷ÓÃ

PL/SQL´æ´¢¹ý³Ì±à³Ì ÊÕ²Ø
  /**author huangchaobiao
*Email:huangchaobiao111@163.com
*/
PL/SQL´æ´¢¹ý³Ì±à³Ì(ÉÏ)
1. OracleÓ¦Óñ༭·½·¨¸ÅÀÀ
´ð£º1) Pro*C/C++/... : CÓïÑÔºÍÊý¾Ý¿â´ò½»µÀµÄ·½·¨£¬±ÈOCI¸ü³£ÓÃ;
2) ODBC
3) OCI: CÓïÑÔºÍÊý¾Ý¿â´ò½»µÀµÄ·½·¨£¬ºÍProCºÜÏàËÆ£¬¸üµ×²ã£¬ºÜÉÙÓÃ;
4) SQLJ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ