in

DevPinoy.org

A Filipino Developers Community
All Tags » SQL Server » Tips (RSS)
ATTENTION:Take our Code Challenge for the month of October 2008 and win some great prize! Learn more about it here!

Browse Site by Tags

Showing related tags and posts accross the entire site.

  • Computing Time Difference

    While Sql Server provides functions to manipulate datetime data types(DateDiff, DateAdd etc.) they don't have(as far as I know) functions to manipulate time. Very useful when computing time differences. In the past I had to manually datediff parts of the time(hh:mm:ss) which wasn't scalable especially...
    Posted to Bonski's Box (Weblog) by bonskijr on 06-23-2007

  • Sql Server Data Type Precedence : Redux

    Previously jokiz bloged about this one , I'd like to add further. The same issue cropped up again in the forums although not the exactly the same as jokiz's experience, this one could really give you hours of head scratching. Previously I was amazed that dynamic ORDER was possible with T-SQL without...
    Posted to Bonski's Box (Weblog) by bonskijr on 04-17-2007

  • Sql Server: How To Restore A Non-Production DB Faster

    Today I was preparing the DB for an implementation of one our module app, I brought along a soon to be production DB . The DB itself was not that big (5GB), however restoring it was taking alot of time. Normally I wouldn't worry about it, but I was on time constraints and the Establishment is working...
    Posted to Bonski's Box (Weblog) by bonskijr on 03-01-2007

  • Sql Server 2005 Tip:Implicit Conversion of bit data types

    Didn't you know that the following statement is now valid for Sql Server 2005 as criteria for a column with bit data type? SELECT * FROM Orders WHERE Processed = 'true' The engine is now intelligent enough to implicitly convert it to SELECT * FROM Orders WHERE Processed = 1 More readable, imo. Too bad...
    Posted to Bonski's Box (Weblog) by bonskijr on 12-09-2006
Page 1 of 1 (4 items)

Copyright DevPinoy 2005-2008
Powered by Community Server (Commercial Edition), by Telligent Systems