Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

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, 1,024 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, 1,228 reads

Posted in Phil Factor's Phrenetic Phoughts: The SQL on 13 January 2011