by Eugene Rosenfeld | Oct 9, 2005 | SharePoint, SharePoint Portal Server 2003, T-SQL, TransactSQL, WSS
IntroductionA very cool aspect of SharePoint’s implementation is the mechanism by which it ghosts pages, that is, stores pages altered with FrontPage in the _site database so they are available to all of the web servers in the server farm. The ProblemHowever, because...
by Eugene Rosenfeld | Oct 8, 2005 | SQL Server, T-SQL, TransactSQL
IntroductionI’ve often needed to seperate out the date or time components from a SQL datetime field. Traditionally, I and many colleagues have converted the datetime to a varchar, used string functions to parse out the desired component, and then converted the...
