Forum Replies Created

Viewing 2 posts - 1 through 2 (of 2 total)

  • RE: Custom Sequence Numbering

    good article; just a quick note on the insert statement; SQL 2008 allows multiple values in one INSERT statement and is quite faster than an "INSERT... SELECT... UNION ALL":

    INSERT INTO...

  • RE: find whether a upper case letter is there in a given string

    Just a quick clarification:

    SQL may consider 'SARAT' , 'Sarat' or 'sarat' as equals; depending on the Collation;

    which means that you should use "...BINARY_CHECKSUM(LOWER('SARAT')..." ;

    if simply using "...LOWER('SARAT')...", then you...

Viewing 2 posts - 1 through 2 (of 2 total)