Thats true.

By the way: http://img144.imageshack.us/img144/2131/freemanae8.jpg 😀

Nice topic.

Just two additional links (Note: The information is mostly for SQL Server 2008, but also relevant for 2005 as well):

http://www.pythian.com/blogs/895/minimal-logging-basics-and-sql-server-2008-enhancements

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

Hi Rohit,

I do not yet understand what you are trying to achieve.

Could you please tell me more details about the process?

Whats the relation between your UPDATE statement and

the data set?...

Hi Doug,

thats exactly the purpose of the question.

If you execute SELECT ISNULL(A,B) FROM #Testyou will get four 1-char strings because of the implicit conversion.

A

S

B

S

Since the length of these is 1,...

Good Question!

The information in the MSDN link is hard to grasp in my opinion (it is a long way from reading "must be implicitly convertible" to understanding that the conversion...

This reminds me of a discussion I had in this board a while ago.

In the end this is the rationale behind it:

SQL Server engine is working with SETs. The SETs...

Thanks for the feedback, dans!

Hi Perry, could you please post an example?

You might go for a two part sort:

SELECT *

FROM units

ORDER BY CASE WHEN unit LIKE '[A-Z]___' THEN CAST(RIGHT(unit,3) AS int) ELSE CAST(unit AS int) END

...

Hello bdavis,

You might be able to do a UNION. You can look up the topic in BOL.

Do the queries return the same columns?

Rohit (9/8/2008)

---

Hi All,

My requirement is like,

I have one table in that table I want to change col1's values and

these values are different for every employee, so currently I have...

Thanks for the feedback guys!

dsegalles80 (9/5/2008)

---

Hi All,

Sorry for the late reply.

Christian Buettner:

Hi dans,

You might try something like in the attached example.

I have not spent too much time verifying it, so it might contain...

This is really useful information, thanks guys!

The QOTD is correct. You cannot create more than 249 indexes on a table.

The referenced MSDN docs are incorrect or at least badly worded.

http://technet.microsoft.com/en-us/library/ms190197.aspx

(And I also tested it)