Sorry Simon, this is not correct (or at least misleading).

The type conversion happens during the concatenation of the two strings.

--...

Why not go one step ahead and store the data in a text file (xml) instead of a database.

Text files even support replication out of the box! And you should...

Hi Mark,

if I read your posts correctly, you are storing both balances AND activity in your ledger table, right?

It might make sense to split these up (maintain the balances separate...

brewmanz.sqlservercentral (5/8/2008)

---

To take the first bit of evidence presented and then dismiss all other evidence that disagrees is a bit...

The question is correct.

And the provided link should be evidence enough.

Good Question!

Although I doubt that this new implicit conversion is an improvement for SQL Server.

I would be interested to know why they have not allowed TRUE or FALSE as bool...

Hm, the answer is kind of paradox.

Either the "the varchar is converted to int" or an "error occurs". But not both.

I would have preferred an answer like this:

...

Great Question! I almost stumbeled...

I only would have added this one as well:

SET ANSI_NULLS OFF

SELECT COUNT(ggg) FROM testnull WHERE ggg=1 OR ggg!=1 OR ggg=NULL;

Christian Buettner (5/2/2008)

---

saimsaboor (5/2/2008)

---

In the "where" Clause the "datename" function is Nondeterministic function also when we use "like" operator then query can not use indexes on that key resulted in...

From my experience, XML is more or less document-centric.

It allows easy validation and "ETL" from a document using XSLT.

If a "document" is only rows & columns, then XML is probably...

saimsaboor (5/2/2008)

---

In the "where" Clause the "datename" function is Nondeterministic function also when we use "like" operator then query can not use indexes on that key resulted in table scan...

As I already stated in one of the previous QODs with a similar question:

The suggested answer does not work with languages other than english...

Try this instead:

WHERE '1;3;4;5;7;8' LIKE '%' +...

Hi Phil,

Doing file handling in ASP.NET doesn't mean you can't make your SQL Server secure. And I am not denying that it is possible to do file handling in SQL...

The problem with this is, that it is also perfectly simple to un-secure your database with xp_cmdshell.

In general you should use the right tools for the right tasks.

And to...

Hello shashank,

In my opinion you should not use the SQL Server DB engine for file handling. I don't know ASP.NET in detail, but I am pretty sure that there must...