SQL Server Performance

DATETIME article by Frank Kalis

Discussion in 'Forum Announcements' started by satya, Apr 11, 2005.

  1. satya Moderator

    http://www.sql-server-performance.com/fk_datetime.asp for more information.
    Keep it up Frank.
  2. Madhivanan Moderator

    It is a very useful article. Thanks satya for giving the link


    Madhivanan

    Failing to plan is Planning to fail
  3. derrickleggett New Member

    Nice article. I'm going to post one of my favorite little pieces of trivia code here. lol



    SET NOCOUNT ON

    DECLARE
    @min INT,
    @max INT,
    @date DATETIME

    SELECT
    @min = 1,
    @max = 131,
    @date = GETDATE()

    SELECT @date

    WHILE @min <= @max
    BEGIN

    IF @min BETWEEN 15 AND 19
    OR @min = 26
    OR @min BETWEEN 27 AND 99
    OR @min BETWEEN 115 AND 119
    OR @min BETWEEN 122 AND 125
    OR @min BETWEEN 127 AND 129
    BEGIN
    GOTO NEXT_LOOP
    END

    SELECT @min, CONVERT(VARCHAR,@date,@min)

    NEXT_LOOP:

    SELECT @min = @min + 1
    END


    MeanOldDBA
    derrickleggett@hotmail.com

    When life gives you a lemon, fire the DBA.
  4. FrankKalis Moderator

    I've referenced your blog entry several times in the German newsgroups already [<img src='/community/emoticons/emotion-2.gif' alt=':D' />]<br /><br />--<br />Frank Kalis<br />SQL Server MVP<br /<a target="_blank" href=http://www.insidesql.de>http://www.insidesql.de</a><br />
  5. ranjitjain New Member

    I found this article as a must read article for all developers.
    thanx satya for posting the link.

Share This Page