Forum Replies Created

Viewing 15 posts - 946 through 960 (of 1,189 total)

  • RE: Physical Database Architecture

    Timothy Ford (5/28/2008)

    Tricky question, but a fair one. I almost got suckered into the 8KB calculation...

    Yes, tricky. I was in fact suckered into the 8 KB calculation. :hehe:

    -------------------
    A SQL query walks into a bar and sees two tables. He walks up to them and asks, "Can I join you?"
    Ref.: http://tkyte.blogspot.com/2009/02/sql-joke.html

    May 28, 2008 at 7:39 am

    #821177

  • RE: Function execution

    thisisfutile (5/21/2008)

    If you force a square peg into a round hole, you will shave the corners...

    I have to admit, I didn't read all the posts

    ...but, some seem to be implying...

    -------------------
    A SQL query walks into a bar and sees two tables. He walks up to them and asks, "Can I join you?"
    Ref.: http://tkyte.blogspot.com/2009/02/sql-joke.html

    May 21, 2008 at 8:32 am

    #818602

  • RE: Function execution

    James Goodwin (5/20/2008)

    Declare @tmp varchar(10)

    set @tmp = '20080520ABCDEF'

    select CAST(@tmp as datetime)

    webrunner,

    Change that to varchar(8) and it will work.

    '20080520AB' cannot be converted to a date, but '20080520' can.

    --

    JimFive

    Right, but my point...

    -------------------
    A SQL query walks into a bar and sees two tables. He walks up to them and asks, "Can I join you?"
    Ref.: http://tkyte.blogspot.com/2009/02/sql-joke.html

    May 20, 2008 at 3:15 pm

    #818255

  • RE: Function execution

    James Goodwin (5/20/2008)

    I think everyone is missing the point of what is happening.

    What is occuring is an automatic type conversion. If I do this:

    Declare @tmp datetime

    set @tmp = '20080101'

    select...

    -------------------
    A SQL query walks into a bar and sees two tables. He walks up to them and asks, "Can I join you?"
    Ref.: http://tkyte.blogspot.com/2009/02/sql-joke.html

    May 20, 2008 at 2:33 pm

    #818225

  • RE: Function execution

    bitbucket (5/20/2008)

    As the author of this QOD, and a SQL developer NOT a DBA, I would like to thank all who entered this discussion. I think the question developed...

    -------------------
    A SQL query walks into a bar and sees two tables. He walks up to them and asks, "Can I join you?"
    Ref.: http://tkyte.blogspot.com/2009/02/sql-joke.html

    May 20, 2008 at 8:45 am

    #817975

  • RE: Function execution

    Christopher Stobbs (5/20/2008)

    I don't think it's a glitch either.

    Like most people are saying the VARCHAR(10) can only hold 10 so SQL is correct in truncating it!!!:D

    SQL may be correct in...

    -------------------
    A SQL query walks into a bar and sees two tables. He walks up to them and asks, "Can I join you?"
    Ref.: http://tkyte.blogspot.com/2009/02/sql-joke.html

    May 20, 2008 at 8:40 am

    #817967

  • RE: Function execution

    Carla Wilson (5/20/2008)

    What this question highlights is that an error is NOT thrown when you pass a parameter value that is too long into the function.

    If you tried that with...

    -------------------
    A SQL query walks into a bar and sees two tables. He walks up to them and asks, "Can I join you?"
    Ref.: http://tkyte.blogspot.com/2009/02/sql-joke.html

    May 20, 2008 at 8:22 am

    #817944

  • RE: Query

    ezlikesundaymorning (5/14/2008)

    Excellent. I guess that I can just sit here and bitch or start contributing myself when it all boils down to it. Thanks for the reply. I am just...

    -------------------
    A SQL query walks into a bar and sees two tables. He walks up to them and asks, "Can I join you?"
    Ref.: http://tkyte.blogspot.com/2009/02/sql-joke.html

    May 14, 2008 at 7:39 am

    #815180

  • RE: Query

    ezlikesundaymorning (5/14/2008)

    OK, just plain and simple, I am going to give my 2 cents worth here. This question is pure BS. I mean has anyone here ever seen a query...

    -------------------
    A SQL query walks into a bar and sees two tables. He walks up to them and asks, "Can I join you?"
    Ref.: http://tkyte.blogspot.com/2009/02/sql-joke.html

    May 14, 2008 at 7:29 am

    #815163

  • RE: Query

    I got the question wrong, which is OK, but I think choices such as "Query is wrong" sound too vague. Perhaps "Query throws an error" or the specific error or...

    -------------------
    A SQL query walks into a bar and sees two tables. He walks up to them and asks, "Can I join you?"
    Ref.: http://tkyte.blogspot.com/2009/02/sql-joke.html

    May 14, 2008 at 7:01 am

    #815132

  • RE: Writing

    I'd love to write more about SQL (or some other nonfiction categories, too) but I don't have anywhere near the talent or experience needed to write something new or authoritative....

    -------------------
    A SQL query walks into a bar and sees two tables. He walks up to them and asks, "Can I join you?"
    Ref.: http://tkyte.blogspot.com/2009/02/sql-joke.html

    May 9, 2008 at 7:39 am

    #813043

  • RE: Bit data

    jim.powers (5/7/2008)

    The question does specifically request the results from SQL Server 2005.

    Yes, it does.

    What will be the result when the following query is executed on SQL Server 2005?

    Also, and this...

    -------------------
    A SQL query walks into a bar and sees two tables. He walks up to them and asks, "Can I join you?"
    Ref.: http://tkyte.blogspot.com/2009/02/sql-joke.html

    May 7, 2008 at 7:18 am

    #811750

  • RE: ANSI_NULLS

    I agree. I think this is a great question. I got it wrong, but it showed me I still have more to learn about NULLs.

    Thanks,

    webrunner

    -------------------
    A SQL query walks into a bar and sees two tables. He walks up to them and asks, "Can I join you?"
    Ref.: http://tkyte.blogspot.com/2009/02/sql-joke.html

    May 6, 2008 at 7:43 am

    #811198

  • RE: T-SQL query

    WayneS (5/2/2008)

    Since the question clearly states:

    The condition should not use both IN and OR operators.

    use could use:

    where DatePart(m, ) IN (1,3,4,5,7,8)

    OR is not used, so since they BOTH...

    -------------------
    A SQL query walks into a bar and sees two tables. He walks up to them and asks, "Can I join you?"
    Ref.: http://tkyte.blogspot.com/2009/02/sql-joke.html

    May 2, 2008 at 7:29 am

    #810066

  • RE: Should I Buy a Kindle?

    Steve Jones - Editor (4/30/2008)

    The half.com idea doesn't really suit me as I won't sell them back. The 1/2 price doesn't really make a difference to me and it's a...

    -------------------
    A SQL query walks into a bar and sees two tables. He walks up to them and asks, "Can I join you?"
    Ref.: http://tkyte.blogspot.com/2009/02/sql-joke.html

    April 30, 2008 at 1:06 pm

    #809271

Viewing 15 posts - 946 through 960 (of 1,189 total)