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

С²¼×÷Æ·£º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
ÔÚÏß¹Û¿


Ïà¹ØÎĵµ£º

SQLµ±Ç°ÈÕÆÚ»ñÈ¡¼¼ÇÉ

SQLµ±Ç°ÈÕÆÚ»ñÈ¡¼¼ÇÉ
select   getdate()   //2003-11-07   17:21:08.597    
  select   convert(varchar(10),   getdate(),120)   //2003-11-07  
  select   convert(char(8),getdate(),112)  ......

NHibernateÖ´ÐÐԭʼSQL´úÂëµÄ·½·¨Ð¡½á

ÔÚʹÓÃNHibernate¹ý³ÌÖо­³£»áʹÓõ½¸´ÔÓµÄsql²éѯ£¬µ«ÊÇʹÓÃhqlÓֱȽÏÂé·³µÄÇé¿öÏ£¬ÎÒÃÇÍùÍù¶¼»áÏëµ½²ÉÓÃԭʼµÄsqlÀ´Ö´ÐС£µ«ÊÇÈçºÎÀûÓÃNHibernateÀ´Ö´ÐÐsqlÄØ£¿ÎÊÌâÀ´ÁË£¬ÔÚNHibernateÖÐÒ²ÓÐAdoTemplateµÄ·½·¨¿ÉÒÔÖ´ÐÐsqlµÄ£¬µ«ÊÇÕâÀïÒª½éÉܵÄÊÇÁíÍâÒ»ÖÖ·½·¨£ºCreateSQLQuery¡£ÒÔϲ¿·ÖÀý×ÓÔ´×ÔÓÚÍøÂç¡£
ʵÀýÒ»£¨Ô´×ÔÓÚ ......

SQL Server Óï¾ä²éѯÊÖ²á

½¨±í£º
CREATE TABLE  [DB.dbo].tableName
(Stud_id int CONSTRAINT  constraintName1  not null primary key,
 Name nvarchar(5) not null,
 Birthday datetime,
 Gender nchar(1),
 Telcode char(12),
 Zipcode char(6) CONSTRAINT constraintName2 CHECK(zipcode like [ ......

sqlÊÂÎñ´¦Àí


 
BEGIN TRANSACTION--¿ªÊ¼ÊÂÎñ
DECLARE @errorSun INT --¶¨Òå´íÎó¼ÆÊýÆ÷
SET @errorSun=0 --û´íΪ0
UPDATE a SET id=232 WHERE a=1 --ÊÂÎñ²Ù×÷SQLÓï¾ä
SET @errorSun=@errorSun+@@ERROR --ÀÛ¼ÆÊÇ·ñÓдí
UPDATE aa SET id=2 WHERE a=1 --ÊÂÎñ²Ù×÷SQLÓï¾ä
SET @errorSun=@errorSun+@@ERROR --ÀÛ¼ÆÊÇ·ñÓдí
I ......

С²¼×÷Æ·£ºSQL*PlusʹÓÃÅàѵ (È«8½²)

==============================================
 
µÚ1½²
ÔÚÏß¹Û¿´£º http://www.boobooke.com/v/bbk1389
ÊÓÆµÏÂÔØ£º http://www.boobooke.com/v/bbk1389.zip
 
µÚ2½²
ÔÚÏß¹Û¿´£º http://www.boobooke.com/v/bbk1390
ÊÓÆµÏÂÔØ£º http://www.boobooke.com/v/bbk1390.zip
 
µÚ3½²
ÔÚÏß¹Û¿´£º http ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ