I have a column in my database called 'Atozlisting', it is filled with only i character in each row of data. the character maybe an alpha character or a Numeral. i.e
a or g or f or 5 or 3 or j... etc
I'm trying to write two SQL statements. The first one will return only records that have an alpha characters as their value and the second one will return records that have a numerals as their value
Using examples as well as descriptions, and references to Books Online, show the documentation available for date manipulation functions and by using a select few of these functions, show how date based data can be manipulated with these functions.
Using examples as well as descriptions, and references to Books Online, show the different Recovery Models available in SQL Server and explain, as well as show how full, differential and transaction log backups are performed