Interesting that this does not work the same way.

select datalength(convert(varchar, getdate(), 101))

Thanks for the question. I learned something. I didn't know that Not ending Transact-SQL statements with a semicolon was on the Deprecated Database Engine Features in SQL Server 2008 R2.

http://msdn.microsoft.com/en-us/library/ms143729.aspx

Thanks,

Kevin

I see...

Really? Would it have been too difficult to return the string unmodified if there was a NULL detected? In the way it is now, a small bug...

Anyone got any ideas why this function was made to work this way? Makes no sense to me.

Sorry if this was already covered. I did read through the 11 pages :doze: and didn't see much on the subject of sort order. Without a specified order wouldn't -3,...

Not for me.

Hugo, is this the article you were looking for?

"The correct behavior for an aggregate...

Rune Bivrin (4/14/2010)

---

It's important to note that SET @result = cast (@@rowcount as varchar) does NOT change @@ROWCOUNT. The first 1 comes from the last INSERT #n VALUES(3).

This is one...

Thanks Hugo! Great explanation.

LOL I lost another point. 🙂

I enjoy QOD and think it is a good learning tool. The idea of points makes it competitive and sometimes taken too seriously IMO.

I believe that this is what the explanation should have been.

The answers are: SELECT COUNT_BIG(ALL COlumn_2) and SELECT COUNT_BIG(column_2). COUNT_BIG(*) will count all rows from the table (including duplicate &...

I don't think I learned anything useful by getting this question wrong. Who cares if you can create a job in express if it can't be used?

This is a new feature in SQL 2008

I found that the reason...

Not for SQL 2008