Forum Replies Created

Viewing 8 posts - 16 through 24 (of 24 total)

  • RE: In The Beginning

    That's exactly what I did. I had no idea I could use a negative number for a datetime!

  • RE: Table valued parameter

    Good question! I knew about the case that a Table UDT is database specific, but I couldn't for the life of me decide which database would work and which...

  • RE: Fun with RAND()

    I forgot RAND() was exclusive. So we can get .99999..., which multiplies to 9.999999..... I take it then that storing a floating point number as an integer just...

  • RE: Does the database exist?

    Alex Gay (11/4/2014)


    DIR is an alias. The command behind it is Get-ChildItem.

    There's a whole slew of commands that are aliased as DIR is. I believe powershell aliased the...

  • RE: Random unions

    TomThomson (10/23/2014)


    Amusing question; the use of RAND is an interesting distraction for a question that is really about UNION ALL and nothing else.

    I agree. I focused on what the...

  • RE: APPLY

    Why was an apply used and not a left join? Is there a reason beyond just needing an example?

  • RE: table variable declaration inside a loop

    If you're allowed to re-declare @j-2 inside the while loop, why are you allowed to select from @j-2 outside of the while loop?

  • RE: Search objects in Database

    Good query!

    Does the 'order by 1,2,3' do anything? To me it looks like it wouldn't, but I wasn't sure if that was some hidden feature that would order by...

Viewing 8 posts - 16 through 24 (of 24 total)