Popular Posts
Join related table and count rows or sum sql server 2005 count rows: SELECT * FROM Table1 LEFT JOIN     (SELECT Level1ID, COUNT(Level2ID) AS Total FROM Table2 GROUP BY Level1ID) AS... Remove file not in list ADD ... THEN ... UNTIL ... data: begin of SERIES, N1 type I value 10, N2 type I value 20, N3 type I value 30, N4 type I value 40, ...
Stats
Detect the condition is null or not
UPDATE
    [fl_news_content]
SET
    [nc_title] = @nc_title,
    [nc_summary] = @nc_summary,
    [nc_content] = @nc_content,
    [nc_date] = @nc_date,
WHERE
    1 = 1
    AND (@nc_create_oid IS NULL or [nc_create_oid] = @nc_create_oid)
OR
UPDATE
    [fl_news_content]
SET
    [nc_title] = @nc_title,
    [nc_summary] = @nc_summary,
    [nc_content] = @nc_content,
    [nc_date] = @nc_date,
WHERE
    1 = 1
    AND [nc_create_oid] = ISNULL(@nc_create_oid,[nc_create_oid])