С²¼×÷Æ·£ºOracle 11g SQL»ù´¡ÈëÃÅϵÁÐÅàѵ(È«30½²)
==============================================
µÚ01½²: Chapter 00--Oracle 11g SQL Fundamentals Training Introduction
ÔÚÏß¹Û¿´£º http://www.boobooke.com/v/bbk2003
ÊÓƵÏÂÔØ£º http://www.boobooke.com/v/bbk2003.zip
µÚ02½²: Chapter 00--Oracle 11g SQL Fundamentals Training Introduction
ÔÚÏß¹Û¿´£º http://www.boobooke.com/v/bbk2004
ÊÓƵÏÂÔØ£º http://www.boobooke.com/v/bbk2004.zip
µÚ03½²: Chapter 01--Restricting Data Using the SQL SELECT Statement
ÔÚÏß¹Û¿´£º http://www.boobooke.com/v/bbk2005
ÊÓƵÏÂÔØ£º http://www.boobooke.com/v/bbk2005.zip
µÚ04½²: Chapter 01--Restricting Data Using the SQL SELECT Statement
ÔÚÏß¹Û¿´£º http://www.boobooke.com/v/bbk2006
ÊÓƵÏÂÔØ£º http://www.boobooke.com/v/bbk2006.zip
µÚ05½²: Chapter 02--Restricting and Sorting Data
ÔÚÏß¹Û¿´£º http://www.boobooke.com/v/bbk2008
ÊÓƵÏÂÔØ£º http://www.boobooke.com/v/bbk2008.zip
µÚ06½²: Chapter 02--Restricting and Sorting Data
ÔÚÏß¹Û¿´£º http://www.boobooke.com/v/bbk2009
ÊÓƵÏÂÔØ£º http://www.boobooke.com/v/bbk2009.zip
µÚ07½²: Chapter 02--Restricting and Sorting Data
ÔÚÏß¹Û¿´£º http://www.boobooke.com/v/bbk2021
ÊÓƵÏÂÔØ£º http://www.boobooke.com/v/bbk2021.zip
µÚ08½²: Chapter 03--Using Single-Row Functions to Customize Output
ÔÚÏß¹Û¿´£º http://www.boobooke.com/v/bbk2022
ÊÓƵÏÂÔØ£º http://www.boobooke.com/v/bbk2022.zip
µÚ09½²: Chapter 03--Using Single-Row Functions to Customize Output
ÔÚÏß¹Û¿´£º http://www.boobooke.com/v/bbk2023
ÊÓƵÏÂÔØ£º http://www.boobooke.com/v/bbk2023.zip
µÚ10½²: Chapter 04--Using Conversion Functions and conditional Expressions
ÔÚÏß¹Û¿´£º http://www.boobooke.com/v/bbk2024
ÊÓƵÏÂÔØ£º http://www.boobooke.com/v/bbk2024.zip
µÚ11½²: Chapter 04--Using Conversion Functions and conditional Expressions
ÔÚÏß¹Û¿´£º http://www.boobooke.com/v/bbk2025
ÊÓƵÏÂÔØ£º http://www.boobooke.com/v/bbk2025.zip
µÚ12½²: Chapter 05--Reporting Aggregated Data Using the Group Functions
ÔÚÏß¹Û¿
Ïà¹ØÎĵµ£º
Select CONVERT(varchar(100), GETDATE(), 23)£»
·µ»ØÐÎʽ£º2008-11-29
Select CONVERT(varchar(100), GETDATE(), 102)
·µ»ØÐÎʽ£º2008.11.29
Select CONVERT(varchar(100), GETDATE(), 101)
·µ»ØÐÎʽ£º11/29/2008
¸ü¶àÏêÇéÇë²Î¼ûÈçÏÂÁÐ±í£º
Select CONVERT(varchar(100), GETDATE(), 0): 05 16 2006 ......
1.Êý¾ÝµÄ·Ö²¼Skip()ºÍtake()
Skip(100)´ú±íÌø¹ý100Ðкó.´ÓµÚ101ÐпªÊ¼·ÖÒ³;
take(10)±íʾ¶àÉÙÐзÖÒ³;
Àý:
var result=from pdt in db.Product
select pdt;
this.dataview.DataSource=result.Skip(10).take(10);
......
ÕÆÎÕSQLËÄÌõ×î»ù±¾µÄÊý¾Ý²Ù×÷Óï¾ä£ºInsert£¬Select£¬UpdateºÍDelete¡£
¡¡¡¡ Á·ÕÆÎÕSQLÊÇÊý¾Ý¿âÓû§µÄ±¦¹ó²Æ ¸»¡£ÔÚ±¾ÎÄÖУ¬ÎÒÃǽ«Òýµ¼ÄãÕÆÎÕËÄÌõ×î»ù±¾µÄÊý¾Ý²Ù×÷Óï¾ä—SQLµÄºËÐŦÄÜ—À´ÒÀ´Î½éÉܱȽϲÙ×÷·û¡¢Ñ¡Ôñ¶ÏÑÔÒÔ¼°ÈýÖµÂß¼¡£µ±ÄãÍê³ÉÕâЩѧϰºó£¬ÏÔÈ»ÄãÒѾ¿ªÊ¼ËãÊǾ«Í¨SQLÁË¡£
¡¡¡¡ÔÚÎÒÃÇ¿ªÊ¼Ö®Ç°£¬ÏÈ ......
¶ÔÓÚsqlÖеĺ¯Êý¿ÉνÊǶàµÄ²»Ê¤Ã¶¾Ù£¬±¾ÎÄ´Ó³£Óú¯ÊýµÄ½Ç¶È¶ÔÆ亯Êý½øÐÐ×ܽ᣺1¡¢ÈÕÆÚºÍʱ¼äº¯Êý2¡¢×Ö·û´®º¯Êý3¡¢ÏµÍ³º¯ÊýÁ÷³Ì¿ØÖÆÓï¾ä
1¡¢ ÈÕÆÚºÍʱ¼äº¯Êý
¶ÔÓÚÈÕÆÚº¯ÊýÎÒÃÇ¿ÉÒÔ·ÖΪ2СÀà½øÐзÖÎö´¦Àí£¬
A¡¢ ÈÕÆÚµÄÕûÌå´¦Àíº¯Êý£¬¾ßÌåµÄº¬ÒåºÍÓï·¨ÈçÏÂËùʾ£º
DATEADD(datepart,number,date)
µÚÒ»¸ö²ÎÊý˵Ã÷ÒªÌí ......