ÖØÐ´SQL Server DateDiffº¯Êý
--½«ÏµÍ³datediffº¯ÊýÖØÐ´£¬Ö÷Òª°ÑdatepartÀàÐ͸ÄΪvarhcar£¬·½±ãµ÷ÓÃ
--×÷Õß:°½Ê¿Î°
--Date:2009-10-14 10:29
create function MyDateDiff(@datepart varchar(50), --ÈÕÆÚ¼ä¸ôÀàÐÍ:year,month,day.etc
@date1 varchar(50), @date2 varchar(50))
returns int
as
begin
declare @part int
if @datepart='year'
begin
set @part=datediff(year,@date1,@date2)
end
if @datepart='month'
begin
set @part=datediff(month,@date1,@date2)
end
if @datepart='day'
begin
set @part=datediff(day,@date1,@date2)
end
if @datepart='week'
begin
set @part=datediff(week,@date1,@date2)
end
if @datepart='hour'
begin
set @part=datediff(hour,@date1,@date2)
end
if @datepart='minute'
begin
set @part=datediff(minute,@date1,@date2)
end
if @datepart='second'
begin
set @part=datediff(second,@date1,@date2)
end
return(@part)
end --½áÊøº¯Êý¶¨Òå
Ïà¹ØÎĵµ£º
°²×°Íê±ÏÖ®ºó£¬»¹ÐèÒªÉèÖÃһϲÅÄÜʹsql·þÎñÁ´½Ó³É¹¦¡£ Ñ¡ÔñµÚÒ»¸ö£º·þÎñºÍÁ´½ÓµÄÍâΧӦÓÃÅäÖÃÆ÷ µã»÷¡°Ô¶³ÌÁ´½Ó¡±£¬ÔÙÑ¡Ôñ±¾µØÁ´½ÓºÍÔ¶³ÌÁ´½Ó¡£Ñ¡ÔñµÚ3¸öÑ¡Ïî¡£ ºÃÁË¡£ÎÒÃÇ¿ÉÒÔµ½¿ªstudioÁË¡£ ¼ÇµÃÔÚ·þÎñÆ÷Ãû³ÆÊäÈ룺localhost\SQLEXPRESS
µÇ¼Ãûsa¡£ÃÜÂë¾ÍÊǰ²×°µÄʱºòÊäÈëµÄÃÜÂë¡£ ok¡£¡£¡£ºÃÁË¡£¡£¡£¡ ......
character-set-server = GB2312
collation-server = latin1_general_ci
MySQL×Ö·û¼¯ GBK¡¢GB2312¡¢UTF8Çø±ð ½â¾ö MYSQLÖÐÎÄÂÒÂëÎÊÌâ ÊÕ²Ø
MySQLÖÐÉæ¼°µÄ¼¸¸ö×Ö·û¼¯
character-set-server/default-character-set£º·þÎñÆ÷×Ö·û¼¯£¬Ä¬ÈÏÇé¿öÏÂËù²ÉÓõġ£
character-set-database£ºÊý¾Ý¿â×Ö·û¼¯¡£
character-set-table£ºÊ ......
1.Ñ¡Ôñ×îÓÐЧÂʵıíÃû˳Ðò(Ö»ÔÚ»ùÓÚ¹æÔòµÄÓÅ»¯Æ÷ÖÐÓÐЧ)¡¡¡¡
¡¡¡¡ SQLSERVERµÄ½âÎöÆ÷°´ÕÕ´ÓÓÒµ½×óµÄ˳Ðò´¦Àífrom×Ó¾äÖеıíÃû£¬Òò´Ëfrom×Ó¾äÖÐдÔÚ×îºóµÄ±í£¨»ù´¡±ídriving table£©½«±»×îÏÈ´¦Àí£¬ÔÚfrom×Ó¾äÖаüº¬¶à¸ö±íµÄÇé¿öÏ£¬±ØÐëÑ¡Ôñ¼Ç¼ÌõÊý×îÉٵıí×÷Ϊ»ù´¡±í£¬µ±SQLSERVER´¦Àí¶à¸ö±íʱ£¬»áÔËÓÃÅÅÐò¼°ºÏ²¢µÄ·½Ê½Á ......
¼ò½é
¡¡¡¡±¾ÎĽ²ÊöMS SQL ServerºÍOracle¶ÔÊý¾Ý¿âÊÂÎñ´¦ÀíµÄ²îÒìÐÔ£¬ÒÔ¼°OracleÈçºÎ¶ÔÊÂÎñ´¦ÀíµÄʵÏÖ¡£
¡¡¡¡Ê²Ã´ÊÇÊÂÎñ
¡¡¡¡Êý¾Ý¿âÊÂÎñ(Database Transaction)ÊÇÒ»×éÊý¾Ý¿â²Ù×÷µÄ´¦Àíµ¥Ôª¡£ÊÂÎñ·ûºÏACIDµÄÌØÐÔ£º
¡¡¡¡Atomic:Ô×ÓÐÔ£¬ÒªÃ´È«²¿ÒªÃ´Ò»ÎÞËùÓС£All or None.
¡¡¡¡Consisten ......