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


  • 44
    Liked
    42
    Learned
    11
    Comments

    SQL Server - IN Clause works the other way, too!

    The IN clause in T-SQL can be used to find a single value present in any one of multiple supplied columns. For example, in the AdventureWorks database: [code] SELECT Title, FirstName, MiddleName, LastName, Suffix FROM Person.Contact WHERE 'Lee' I......
    SQL Server Tips
    Jeffem  Posted on Sep 24 2011 11:34AM
    Last reply by Santosh Srivastava at 2012-08-29 06:03:23
  • 8
    Liked
    9
    Learned
    10
    Comments

    Calculating Multiplication on row wise

    Yesterday night, I was reading Inside Microsoft Sql server 2008: Programming - Itzik Ben-Gen. On Cursors section Page number 291, he has tried to explain the scenario for calculating multiplication on row wise manner. He has explained through cursor. Be...
    SQL Server Tips
    Jeetendra  Posted on Aug 29 2012 12:00AM
    Last reply by Alok Chandra Shahi at 2012-09-07 13:20:29
  • 7
    Liked
    4
    Learned
    10
    Comments

    Sql server neglects trailing spaces

    create table #temp ( a varchar(10) ) insert into #temp values(' a ') select COUNT(*) from #temp where a=' a' select COUNT(*) from #temp where a='a' first query will return 1 2nd will return 0 as sql ser...
    SQL Server Tips
    satyajit  Posted on Jul 13 2012 12:00AM
  • 20
    Liked
    11
    Learned
    10
    Comments

    Sargable vs Non-sargable

    I have always heard about the terms sargable and non-sargable but never really understood how they help in developing efficient sql code. Here is what I have found out... Try to avoid WHERE clauses that are non-sargable. The term “sargable” (which is i...
    SQL Server Tips
    vanne040  Posted on Feb 2 2012 12:00AM
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]