Can experts in Microsoft SQL offer some book recommendations on T-SQL query and data import/export?
I am looking for this to do some self-study.
Some examples ( to use it in SQL 2005 query analyzer or in ACCESS 2007 environment ):
How to convert 20080723 to be a date 7/23/2008 in ACCESS 2007?
How to use query to remove non-number characters so that 904-287 - 9276 or (904)287-9276 will become 9042879276?
How to filter out rows with non-number/non-letter characters from a table: 13245a98, 1625h2872, 187am@$%9, so that 187am@$%9 will be filterred out?
How to filter out rows with multiple spaces between comma and letters: (Smith, Adam), (Jenner, Tom), so that (Smith, Adam) will be filterred out ( Lastname, then comma, one space, then Firstname ) ?
Some query solutions are very welcome for the above questions.
I appreciate your input and recommendation.
I am looking for this to do some self-study.
Some examples ( to use it in SQL 2005 query analyzer or in ACCESS 2007 environment ):
How to convert 20080723 to be a date 7/23/2008 in ACCESS 2007?
How to use query to remove non-number characters so that 904-287 - 9276 or (904)287-9276 will become 9042879276?
How to filter out rows with non-number/non-letter characters from a table: 13245a98, 1625h2872, 187am@$%9, so that 187am@$%9 will be filterred out?
How to filter out rows with multiple spaces between comma and letters: (Smith, Adam), (Jenner, Tom), so that (Smith, Adam) will be filterred out ( Lastname, then comma, one space, then Firstname ) ?
Some query solutions are very welcome for the above questions.
I appreciate your input and recommendation.
