HanShi (10/6/2008)

---

I thought putting the integer value 500000 into a varchar(5) would result in a string with value '50000' (removed last 0). Now I learned it's resulting in a string...

My answer was correct but my reasoning for getting to the answer seemed to have been incorrect; I thought the error would be generated on printing integer and varchar variables...

I work inland, so my vacations are normally a seaside one, and most of the time we'll be swimming or just enjoying the time in the sun or outside for...

I hit the gym at least 4 time a week doing primarily weight training.

I'm starting to focus again on interval training on one of those rowing machines as I'm starting...

Hugo

Thanks for the feedback on my query

I have to admit, i haven't worked with SQL 2005 yet, so the fact that the mentioned tables in SQL2005 is being depreciated, was...

Schweet..

Just make sure your QotD isn't confusing, misleading, can be misinterpreted or anything, cause i've seen where the guys were taken to the cleaners because the submitted question was either...

i use this to find text in any db object:

-----------------------------------------------------

declare @criteria as varchar(32)

set @criteria = 'tadMSVRAreaDetail'

--:Utility proc for searching for dependents.":--

Select 'Checking references for (' + @criteria + ')'

Select distinct...

I lost the point as well, fortunately for the better of learning something new.

This was very interesting to me, as all the years of just trusted BOL in being correct,...

that means irrespective of anything, the "into" is optional.

I can concur on the optional "into", but if memory serves me correctly, if you specify the columns to be inserted, one has to include the "into", or is it...

Proof that you can teach an old dog some new tricks, probably depends on the willingness to learn though... thanks for the question

I stepped into the answer to quickly as well.... unfortunately selecting yes, as my "interpretation" also (like many others) was running the query on select #1 and #2 multiple times,...

:D, a difinition glitch, i think that is the right answer....

i haven't worked alot in SQL 2005, but even from my SQL 2000 experience you can't fit anything bigger that...

I agree with Jack's last comment, it's excellent to have structure in place in terms of standards, and as I mentioned in the beginning of this discussion, this is a...

Interesting point on filters and sub selects, but I thought the question was a bit misleading in terms of the possible answers provided:

- From a syntax point of view, I...