Subscribe to this blog
Archives: January 2011
A Quick TRIM, Sir?
The other day, I was answering a question on the ASK.SQLSERVERCENTRAL.COM forum from a programmer who had hit a problem where he thought that LTRIM and RTRIM had failed to work. Although, I wasn’t entirely certain, I felt sure it was because of the 'Nul' characters that he admitted had… Read more
0 comments, 660 reads
Posted in Phil Factor's Phrenetic Phoughts: The SQL on 28 January 2011
Silly Billiseconds
You have to admire Microsoft for sticking to their guns, even when being palpably stupid. I refer, of course to the SqlDateTime structure constructor in .NET 2 through to 4. See here
public SqlDateTime(
int year,
int month,
int day,
int hour Read more
6 comments, 714 reads
Posted in Phil Factor's Phrenetic Phoughts: The SQL on 13 January 2011