Viewing 15 posts - 781 through 795 (of 825 total)
Lynn Pettis (7/23/2009)
There really should have been a third choice: It Depends. It really does, what data type is being converted to what data type?
For example you can't eliminate...
July 23, 2009 at 10:04 am
Not always. Converting varchar to int, may fail if some value is not numeric.
July 23, 2009 at 12:50 am
EdVassie (7/2/2009)
I have seen some poor database designs that have ignored this fact, with varchar(1), varchar(2), etc fields.
Everybody always should use the RIGHT type.
varchar(1) and char(1) are not similar nor...
July 2, 2009 at 3:51 am
I answered varchar(1), because I like to use varchar. I hate CHAR cause of big problem that can lead, and NCHAR NVARCHAR cause of waste of space.
June 5, 2009 at 9:59 am
Old style to write the WHERE condition.
I prefer to build a string ONLY with the true condition; it's more performing.
In a complex WHERE with useless condition may lead to a...
June 1, 2009 at 12:56 am
c:\ and C:\mssql\ should exists and sql account should have permissions to write.
May 11, 2009 at 1:15 am
this question is the same of "predict output".
Also the second answer is correct, cause of lack of ORDER BY.
April 22, 2009 at 12:52 am
Vaccano (4/21/2009)
Check your "Messages" tab after it has run. It outputs a report to that tab. (Though if you db is error free then it will do "nothing".)Vaccano
I...
April 22, 2009 at 12:47 am
Correct answer is 1-25:
exec sp_helptext sp_addmessage
in the output search for @severity and you'll find this piece of code that is the law.
--...
April 16, 2009 at 3:13 am
Viewing 15 posts - 781 through 795 (of 825 total)