Viewing 15 posts - 766 through 780 (of 812 total)
Mighty (10/1/2009)
I'm of the opinion that the answer(s) are incorrect.CUBE and ROLLUP where already available in SQL Server 2005, so they were not introduced with SQL Server 2008.
CUBE and ROLLUP...
October 1, 2009 at 7:14 am
dave.farmer (9/7/2009)
I added 10,000 rows (actually 10,001 - as below) and this time query 1...
September 7, 2009 at 6:27 am
Artur Sokhikyan (8/4/2009)
nice question-------------------------
- Name?
- Abu Dalah Sarafi.
- Sex?
- 3 times a week!
- No, no. Male or Female?
- Male, female, sometimes camel...
Strong!!!!
August 4, 2009 at 2:00 am
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
Viewing 15 posts - 766 through 780 (of 812 total)