A. A.
select CASE
WHEN dateadd(year, datediff (year, d1, d2), d1) > d2
THEN datediff (year, d1, d2) - 1
ELSE datediff (year, d1, d2)
END as Age
A. Yes you can, but any un-committed transactions will be lost. This command is unsupported and undocumented so should be used with caution. It works on SQL 6.5 - whether it works on 7.0 is unknown...
A. It could be a variety of things...
A. To store/retrieve this sort of data within TSQL scripts you have to use the WRITETEXT and READTEXT commands rather than standard INSERT/SELECT statements. These are documented, with examples, in the books-online but are basically a real pain...
A. Check the following table :...
A. Here is a script courtesy of fellow MVP, Bob Pfeiff. Note, it will only get rid of one CRLF per column, so you may want to stick the update in loop and keep doing it until you get a zero rowcount...