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

PL/SQLÓαê×ܽá

Óα꣺ָÏò´¦ÀíSQLÓï¾äµÄ»·¾³ÇøÓòµÄÖ¸Õë»ò¾ä±ú
-----|-1 ¾²Ì¬Óαê
       |---1.1 ÒþʽÓαê
       |          ´¦Àí£ºINSERT,DELETE,UPDATE¼°·µ»ØÒ»ÐеÄSELECTÓï¾ä
       |          ²Ù×÷£ºÓÉPL/SQL×Ô¶¯¶¨Òå²¢Íê³É´ò¿ªÓë¹Ø±Õ¶¯×÷
       |          ÊôÐÔ£º%FOUND,%NOTFOUND,%ISOPEN,%ROWCOUNT
       |---1.2 ÏÔʾÓαê
       |          ´¦Àí£º·µ»Ø¶àÐеÄSELECTÓï¾ä
       |          ²Ù×÷£º1.2.1 ÏÔÊ¾ÍÆ½øÑ­»·
       |                                --ÉùÃ÷Óαê
       |                                --´ò¿ªÓαê
       |                                --ÍÆ½øÓαê
       |                                --¹Ø±ÕÓαê
       |                     1.2.2 ×Ô¶¯ÍƽøÑ­»·
       | 


Ïà¹ØÎĵµ£º

´æ´¢¹ý³Ì£¬ Éú³ÉSQLÓï¾ä

USE [sfaecrm]
GO
/****** ¶ÔÏó:  StoredProcedure [dbo].[proc_insert]    ½Å±¾ÈÕÆÚ: 05/29/2009 06:16:07 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER proc [dbo].[proc_insert] (@tablename varchar(256))
as
begin
        set ......

Ò»²½Ò»²½Ñ§Linq to sqlϵÁÐÎÄÕÂ

ÏÖÔÚLinq to sqlµÄ×ÊÁÏ»¹²»ÊǺܶ࣬±¾ÈËˮƽÓÐÏÞ£¬Èç¹ûÓдí»òÕßÎóµ¼ÇëÖ¸³ö£¬Ð»Ð»¡£
Ò»²½Ò»²½Ñ§Linq to sql£¨Ò»£©£ºÔ¤±¸ÖªÊ¶
Ò»²½Ò»²½Ñ§Linq to sql£¨¶þ£©£ºDataContextÓëʵÌå 
Ò»²½Ò»²½Ñ§Linq to sql£¨Èý£©£ºÔöɾ¸Ä
Ò»²½Ò»²½Ñ§Linq to sql£¨ËÄ£©£º²éѯ¾ä·¨
Ò»²½Ò»²½Ñ§Linq to sql£¨Î壩£º´æ´¢¹ý³Ì
Ò»²½Ò»²½ ......

ÇóÖúSQL SERVER 2008Á¬½ÓÎÊÌâ

²âÊÔ»útest°²×°µÄÊÇwindows server2008+sql server 2008£¬Êý¾Ý¿â°²×°³É¹¦¡£¿ÉÒÔÁ¬½Ó¾ÖÓòÍøÄÚÆäËû»úÆ÷µÄÊý¾Ý¿â£¨ÆäËû»úÆ÷µÄÊý¾Ý¿âΪSQL 2005£©¡£µ«ÊÇÍøÄÚÆäËû»úÆ÷·ÃÎÊtestʱ£¬ÎÞ·¨Á¬½Ó£¬±¨´í¡£ÐÅϢΪ£ºÔÚ½¨Á¢Óë·þÎñÆ÷µÄÁ¬½Óʱ³ö´í¡£ÔÚÁ¬½Óµ½SQL SERVER 2005ʱ£¬ÔÚĬÈϵÄÉèÖÃÏÂSQL SERVER ²»ÔÊÐí½øÐÐÔ¶³ÌÁ¬½Ó¿ÉÄܻᵼÖ´Îʧ°Ü ......

SQL ConvertµÄÓ÷¨

CONVERT º¯Êý [Êý¾ÝÀàÐÍת»»]
--------------------------------------------------------------------------------
¹¦ÄÜ 
·µ»Ø×ª»»³ÉÌṩµÄÊý¾ÝÀàÐ͵ıí´ïʽ¡£
Óï·¨ 
CONVERT ( data type, expression [ , format-style ] )
²ÎÊý 
data&nbs ......

SQL ³£ÓÃÓï¾ä

(1)Êý¾Ý¼Ç¼ɸѡ£º
sql="select*fromÊý¾Ý±íwhere×Ö¶ÎÃû=×Ö¶ÎÖµorderby×Ö¶ÎÃû[desc]"
sql="select*fromÊý¾Ý±íwhere×Ö¶ÎÃûlike'%×Ö¶ÎÖµ%'orderby×Ö¶ÎÃû[desc]"
sql="selecttop10*fromÊý¾Ý±íwhere×Ö¶ÎÃûorderby×Ö¶ÎÃû[desc]"
sql="select*fromÊý¾Ý±íwhere×Ö¶ÎÃûin('Öµ1','Öµ2','Öµ3')"
sql="select*fromÊý¾Ý±íwhere× ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ