黑咚咚飲料茶試喝

今天中午回來發現公司販賣機多了個新貨--爽健美茶黑覺醒烏龍複合茶, 立刻投了5塊錢來試試..

A note for sql: todo foreach group string join without cursor v 0.5

SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO

-- =============================================
-- Author:        Irene
-- Create date: 2012/5/14
-- Description:    TaskResponse更新資料後 維護Event.FinishCount
-- =============================================
ALTER TRIGGER [dbo].[trTaskResponse] ON [dbo].[TaskResponse]
    AFTER INSERT,DELETE,UPDATE
AS
BEGIN
    -- SET NOCOUNT ON added to prevent extra result sets from
    -- interfering with SELECT statements.
    SET NOCOUNT ON;
    
    -- Insert statements for trigger here
    --控制範圍
    DECLARE @statusid int;
    DECLARE @eventid int;
    DECLARE @memberid int;
    SELECT @statusid=r.StateId, @memberid=r.MemberId, @eventid=t.EventId
        FROM DELETED r INNER JOIN Task t ON r.TaskId=t.TaskId;
    SELECT @statusid=r.StateId, @memberid=r.MemberId, @eventid=t.EventId
        FROM INSERTED r INNER JOIN Task t ON r.TaskId=t.TaskId;
    --INSERT INTO DBLog VALUES ('statusid='+cast(@statusid as varchar(5))+',memberid='+cast(@memberid as varchar(5))+',eventid='+cast(@eventid as varchar(5)));
    /*
    IF (@statusid<>1)
    BEGIN
        --INSERT INTO DBLog VALUES ('statusid='+cast(@statusid as varchar(5))+'memberid='+cast(@memberid as varchar(5))+',eventid='+cast(@eventid as varchar(5)))
        RETURN;
    END
    */
    IF (@eventid IS NULL AND @memberid IS NULL)
    BEGIN
        RETURN;
    END

SQL Server OrderBy Nulls Last

Oracle的特異功能還真多~ ^^y

很少直接下command了.. (￣▽￣///) _筆一下

Linq

dcx.Task.Where(t => t.EventId == parentId).OrderBy(t => !t.StartDate.HasValue).ThenBy(t => t.StartDate)

Command

SELECT * FROM Task WHERE EventId=@parentId ORDER BY ISDATE(StartDate) DESC, StartDate

JavaScriptSerializer並沒有什麼問題好咩

由於一直都是用Json.NET, 從來都安穩沒代誌..
雖然知道有內建System.Runtime.Serialization.Json.DataContractJsonSerializer和System.Web.Script.Serialization.JavaScriptSerializer這東東, 但還得用System.ServiceModel.Web.dll和System.Runtime.Serialization.dll或System.Web.Extensions.dll, 真的沒啥興趣去弄它..

今天同事說他都用JavaScriptSerializer, 還說Deserialize時DateTime會轉不回來..
好奇之下去試了一下....

奧妙的不等式

今天學到一句話
「二個人不等於一人+一人」

雖然它對本宅犬而言尚且屬於神秘不可知的領域, 但總覺得留下來可以細細品味..

這句話是偶像宛秀小姐跟本宅犬講的, 當下本想問她, 那究竟是二個人大於一人+一人咧? 還是二個人會小於一人+一人? 不過轉念一想, 這...沒有一定吧~

而且是要情境到時才能體會的啊 ^_^ 恐怕還是如人飲水, 各人不同呢..