LinkedIn
RSS

Archive for April 21st, 2009


Difference between select single and up to 1 row

GA_googleFillSlot(“POSTSAP”); The ‘SELECT SINGLE’ statement selects the first row in the database that it finds that fulfils the ‘WHERE’ clause If this results in multiple records then only the first one will be returned and therefore may not be unique. The ‘SELECT ….*….. UP TO 1 ROWS’ statement is subtly different. The database selects all of [...]

Read More...