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

sql陽曆轉陰曆

USE [rossic]
GO
/****** Object:  StoredProcedure [dbo].[fn_GetLunar]    Script Date: 02/23/2010 15:46:19 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
     
CREATE     proc   [dbo].[fn_GetLunar]          
 -- RETURNS   datetime   
  @solarDay   DATETIME ,  
  @OUTPUTDATE   DATETIME  output   
  AS          
  BEGIN          
      DECLARE   @solData   int        
      DECLARE   @offset   int         
      DECLARE   @iLunar   int      
      DECLARE   @i   INT          
      DECLARE   @j   INT           
      DECLARE   @yDays   int       
      DECLARE   @mDays   int         
      DECLARE   @mLeap   int          
      DECLARE   @mLeapNum   int        
      DECLARE   @bLeap   smallint      
      DECLARE &nbs


Ïà¹ØÎĵµ£º

PL/SQL ѧϰ±Ê¼Ç3

 SQL> var a number
SQL> begin
2 :a :=1000;
3 end;
4 /
PL/SQL procedure successfully completed.
SQL> edit
Wrote file afiedt.buf
1 begin
2 dbms_output.put_line(:a);
3* end;
SQL> /
ͨ¹ýÕâ¸ö´úÂë¿ÉÒÔ¿´³öͨ¹ýpl/sql³õʼ»¯¸³ÖµµÄBind variable¿ÉÒÔ±»ÆäËûPl/sql³ÌÐòµ ......

ÈçºÎд¸ßЧµÄÅúÁ¿²åÈëºÍɾ³ýsqlÓï¾ä

×÷Õߣº²»Ïê ³ö´¦£ºÍøÂç×ªÔØ  2009/11/18 10:35:22 ÔĶÁ 109  ´Î
¡¡¡¡¼¼Êõˮƽ×ÜÄÜÔÚ³¶Æ¤ºÍ´µÃ«Çó´ÃÖеõ½Ìá¸ß¡£Èç¹û´ÓÀ´²»“Çó´Ã”£¬¿ÉÄܾͲ»»áÖªµÀif(str != "")²»Èçif(str != string.Empty)¸ßЧ¡¢ÅúÁ¿²åÈëºÍɾ³ýµÄsqlÓï¾äÊÇÒªÄÇÑùд²ÅÖ´ÐÐ×î¿ì¡¢½Ó¿ÚºÍ³éÏóÀàµÄÇø±ð²»½öÊÇÓïÑÔ²ãÃæ¡¢ ......

SQL Server°²×°³ö´í½â¾ö

SQL Server°²×°³ö´íÎÊÌâ½â¾ö
ÏÈ
°ÑSQL ServerÐ¶ÔØ£¬ÔٰѰ²×°Ê±²úÉúµÄ“Microsoft SQL
Server”Îļþ¼Ðɾµô,ÔÚÔËÐÐ×¢²á±í,°ÑHKEY_CURRENT_USER\\Software\\Microsoft\\Microsoft
SQL Server£¬ºÍHKEY_LOCAL_MACHINE\\SOFTWARE\\Microsoft\\Microsoft SQL
ServerÈ«²¿É¾µô£¬(×¢ÒâÒª°ÑMicrosoft SQL ServerÎļþ¼ÐÕ ......

SQLʵÀý

--1¡¢²éÕÒÔ±¹¤µÄ±àºÅ¡¢ÐÕÃû¡¢²¿ÃźͳöÉúÈÕÆÚ£¬Èç¹û³öÉúÈÕÆÚΪ¿ÕÖµ£¬ÏÔʾÈÕÆÚ²»Ïê,²¢°´²¿ÃÅÅÅÐòÊä³ö,ÈÕÆÚ¸ñʽΪyyyy-mm-dd¡£
select emp_no,emp_name,dept,isnull(convert(char(10),birthday,120),'ÈÕÆÚ²»Ïê') birthday
from employee
order by dept
--2¡¢²éÕÒÓëÓ÷×ÔÇ¿ÔÚͬһ¸öµ¥Î»µÄÔ±¹¤ÐÕÃû¡¢ÐԱ𡢲¿ÃźÍÖ°³Æ
select ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ