Good question! When I first saw it, I thought there would be a very high percentage of correct answers since the confusing default lengths for character strings have already been covered in a few recent QotD's. But the results say that at this time, only 53% of the respondents have given the right answer, so there is obviously still a lot of need to keep driving this point home. Good job, magasvs!
Bhuvnesh (8/9/2010)
30 is for char or varchar ?
Both, when used without length in a CONVERT() function call.
In a DECLARE, both char and varchar default to a length of 1.