Old question and repeated many times.

Richard M Karpel (12/16/2010)

---

Now, I read the section highlighted in BOL, and I expected to get the not defined error message, but I would need to look further and see...

It depends on "Regional Settings".

:-D:-D:-D:-D

The QOtD asks for what is the output of a specific script and this generates this error:

Insert Error: Column name or number of supplied values does not match table definition.

and...

Mayan calendar BUG: 12/12/2012 is the end.

:-D:-D:-D

It's best to use the format 'yyyymmdd' because it's indipendent from "regional setting".

I always use this this syntax:

RIGHT('0000000000' + CAST(SomeNumber AS VARCHAR(10)),10)

Because I didn't know that STR() is also used for formatting, I thought it only converts string to number.

This is an old kind of COBOL bug:

using bad datatype to hold integer:

01 IDX PIC 9.

PERFORM LBL VARYING IDX BY 1 UNTIL IDX > 10.

Endless loop

When I realize that a command or option is deprecated, I stop to waste my time to use it.

Now, I understand because

set ansi_padding off is deprecated, it's buggy.

Nils Gustav Stråbø (12/6/2010)

---

Good question, thanks!

Is it just me, or is there a bug in SQL Server when ANSI_PADDING is OFF (not that I've ever used it)?

Let me demonstrate, and...

The INSERT SCRIPT should be executed twice: one with ANSI_PADDING option set to ON and another one to...

Thank you! Finally a very good question.

The only worth of the question is the good news:

"filtered index" (SQL Server 2008).

This feature is present in MS-ACCESS starting from version 1.0 (year 1990).

INSERT ... WHERE ...

... and UPDATE ????

I could insert NULL and then change (UPDATE) it to an existing value!

The solution is insert/update by stored proc, but the risk to miss...