Viewing 2 posts - 1 through 2 (of 2 total)
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...
June 17, 2013 at 9:14 am
#1624645
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...
May 24, 2012 at 12:30 pm
#1492722