Forum Replies Created

Viewing 10 posts - 1 through 10 (of 10 total)

  • RE: Find the directory in R

    I agree that getwd() returns the "working" directory, but, that was not the question. The question was "How can I determine my CURRENT directory?"  They can be the same, or...

  • RE: Ignoring Database Version Control

    Yes, and sometimes the comments in that "Boilerplate" comment section entails many times the size of the the working code. More importantly, it provides a "paper trail" when...

  • RE: Ignoring Database Version Control

    Having the schema's and sprocs in a VCS helps immeasurably when you are trying to figure out what, where, why a change was made. Even just knowing who did...

  • RE: Ignoring Database Version Control

    We use TFS here in my shop. The web developers had been using it for several years and finally this year the database team set up and started using...

  • RE: How Far Have You Traveled for a SQL Saturday?

    I have been fortunate that I only have to travel about 20 miles to attend both Sql Saturday and Code Camp events here in San Diego California. Unless I...

  • RE: Need to insert Reocrds in uniqueidentifier column

    ChrisM@home (4/20/2011)

    It doesn't work because '00000000-0000-0000-000-0000000000' won't cast to a uniqueidentifier. Try this:

    SELECT CAST('00000000-0000-0000-000-0000000000' AS uniqueidentifier)

    SELECT CAST('00000000-0000-0000-0000-000000000000' AS uniqueidentifier)

    Why do you want to put this value into a uniqueidentifier column?...

  • RE: Getting index columns

    Rounding error?

  • RE: Getting index columns

    I wasn't sure about this one, so I had to do a lot of research... Really, I did! 🙂


  • RE: Fun with RAND()

    I also believe the answer is misleading. The select will return 1 row, 1 to 9 times, each one is a separate select of 1 row. A better...

  • RE: How Many Different Random Numbers?

    I get 3 distinct random numbers on my dev database and 6 distinct random numbers using the master database. I am using Sql Server 2005.

Viewing 10 posts - 1 through 10 (of 10 total)