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

PL/SQL ÖеÄSQLÓï¾ä

ÀýÈ磺
ÆÕ±éµÄSQLÓï¾ä£º
          update book set bookname='sssss' where bookId=1;   
ÔÚPL/SQL ÖÐÖ´ÐУº 
          declare
           v_bookId number;
        begin
           v_bookId :=1;
           update book set bookname='sssss' where bookId=v_bookId;         
        end;
1£¬select
  ÔÚPL/SQL ³ÌÐòÖУ¬Ê¹ÓÃselect ...into Óï¾ä²éѯһ¸ö¼Ç¼µÄÐÅÏ¢£¬ÆäÓ﷨Ϊ£º
  select select_list_item into variable_list | record_variable from table where condition;
 ÀýÈ磺¸ù¾ÝÊéÃû»òÊéºÅ²éÕÒÊéµÄÐÅÏ¢¡£
declare
          v_bookId book.bookId%type;
          v_bookname book.bookname%type;
          v_table book%rowtype;
        begin
          select * into v_table from book where bookId=1;
          Dbms_Output.put_line('v_table.bookId '|| v_table.bookId || '  v_table.bookName ' || v_table.bookName);
          select bookId,bookName into v_bookId,v_bookname from book where bookId=1;
          Dbms_Output.put_line('v_bookId  '|| v_bookId || '  v_bookname  ' || v_bookname);
        end;
×¢Ò⣺
 select ...intoÓï¾äÖ»Äܲéѯһ¸ö¼Ç¼µÄÐÅÏ¢£¬Èç¹ûûÓвéѯµ½ÈκÎÊý¾Ý£¬»á²úÉúNO_DATA_FOUNDÒì³££»Èç¹û²éѯµ½¶àÌõ¼Ç¼£¬Ôò»á²úÉúTOO_MANY_ROWÒì³£¡£
into ¾ä×ÓºóµÄ±äÁ¿ÓÃÓÚ½ÓÊÕ²éѯµÄ½á¹û£¬±äÁ¿µÄ¸öÊý£¬Ë


Ïà¹ØÎĵµ£º

sqlÓï¾ä ʱ¼ä¸ñʽת»»£¨ConvertÓ÷¨£© ²Î¿¼

Select CONVERT(varchar(100), GETDATE(), 0): 05 16 2006 10:57AM
Select CONVERT(varchar(100), GETDATE(), 1): 05/16/06
Select CONVERT(varchar(100), GETDATE(), 2): 06.05.16
Select CONVERT(varchar(100), GETDATE(), 3): 16/05/06
Select CONVERT(varchar(100), GETDATE(), 4): 16.05.06
Select CONVERT(varch ......

IBatisNet SQL ServerµÄfloatÀàÐÍת»»Îªc# float³ö´í

½ñÌìдһ¸öÉÌÆ·µÄÐ޸ŦÄÜʱÓöµ½µÄÎÊÌâ
ÉÌÆ·ÖÐÖØÁ¿ weight µÄÊý¾Ý¿â(SQL Server2005)ÀàÐͶ¨ÒåΪ float
ÔÚmappings ÖÐת»»Îªc#ÀàÐ͵ÄÒ»¾äΪ
<result property="Goods_Weight" column="Goods_Weight" type="float" dbType="float"/>
°´Àí˵Õâ¸ö float ÊÇÒ»ÑùµÄ£¬×ª»»ÍêÈ«²»»á³öÏÖÎÊÌ⣬
ʵ¼Ê³ÌÐòÔËÐÐʱ£¬ÏµÍ³±¨´í ......

ʹÓÃSQLÓï¾äÉú³ÉÊý¾Ý×Öµä

--sqlserver 2000
SELECT ±íÃû=case when a.colorder=1 then d.name else '' end,
--×Ö¶ÎÐòºÅ=a.colorder,
×Ö¶ÎÃû=a.name,
--
±êʶ=case when COLUMNPROPERTY( a.id,a.name,'IsIdentity')=1 then '√'else '' end,
/**/
Ö÷¼ü=case when exists(SELECT 1 from sysobjects where xtype='PK' and name
in ( ......

sqlÓï¾äѧϰ±Ê¼Ç(5) sqlÓï·¨

1.sqlÊÇÒ»Öֽű¾ÓïÑÔ
2.sql¿Éд½Å±¾³ÌÐò£¬µ«×îÖØÒªµÄ×÷Ó÷¢»ÓÔÚ¶ÔÊý¾Ý¿âµÄ²Ù×÷ÉÏ
3.sql server2005ÖеÄ×¢ÊÍÓÐÁ½ÖÖ/***/¶àÐÐ×¢ÊÍ£¬--¿ÉÒÔµ¥ÐÐ×¢ÊÍ
4.sqlÖеÄ×Ô¶¨Òå±äÁ¿ÒÔ@¿ªÍ·£¬ÏµÍ³±äÁ¿ÒÔ@@¿ªÍ·
5.sqlÖÐÉùÃ÷±äÁ¿ºÍVBÀàËÆ£¬Ê¹ÓÃdeclareÉùÃ÷±äÁ¿È磺declare @i int,@j int£¬´ËÓï¾äÉùÃ÷ÁË2¸öÕûÐαäÁ¿@iºÍ@j
6.sqlÖеÄÊý¾Ý ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ