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...

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...

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...

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...

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...

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?...

Rounding error?

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

Chief

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...

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.