Getting Started with Adobe After Effects - Part 6: Motion Blur
A collection of quick technology learning tips from what people around you learn every day


  • 13
    Liked
    8
    Learned
    2
    Comments

    ISNULL vs NULLIF

    My team mate was working with legacy code. Code used ISNULL and NULLIF functions, he got confused becauase of similar name. Thought of sharing with you all. ISNULL - Replaces NULL with the specified replacement value. NULLIF - Returns a null ......
    SQL Server Tips
    Hardik Doshi  Posted on Sep 20 2011 9:19AM
  • 13
    Liked
    15
    Learned
    7
    Comments

    Semicolon can be used to execute a procedure

    Is it unbeleivable? See the below example [code]Create procedure GO as select 1 as number[/code] Now execute it without using keywords EXEC or EXECUTE [code]GO[/code]GO is treated as batch seperator and you wont get any result. Now execute it by[......
    SQL Server Tips
    Madhivanan  Posted on Jun 13 2011 3:18AM
  • 13
    Liked
    5
    Learned
    4
    Comments

    SQL Server - INTERSECT and EXCEPT

    'EXCEPT' will show any distinct value from first query result that is not found in second query result. Select item_id from itemmaster except Select item_id from stock 'INTERSECT' will show any distinct values, which are common in both first & ......
    SQL Server Tips
    Deepak kelath  Posted on Nov 19 2011 2:15PM
  • 13
    Liked
    14
    Learned
    0
    Comments

    SQL Server - New warnings in Actual Execution Plan

    Recently learned from Ana's blog here that, in Denali, now execution plan will show some warnings also. While executing query, if it finds any bottlenecks, it will show the warnings in the execution plan against that iterator. When you see the actual......
    SQL Server Tips
    Ramireddy  Posted on Oct 24 2011 11:37AM
Previous 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | ... Next
    Copyright © Rivera Informatic Private Ltd Contact us      Privacy Policy      Terms of use      Report Abuse      Advertising      [ZULU1097]