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...

tommyh (12/2/2010)

---

There is no **** way that "By adding a where clause in ALL inserts that checks for the existence of new value in the table" is a fix to...

I disagree: the query returns all rows that contains the word 'order' in the column [text] that may appear in comments or definition.

Carlo Romagnano (11/22/2010)

---

WayneS (11/22/2010)

---

BTW, the best way to check for the existance of a temporary table in your current session is:

IF OBJECT_ID('tempdb..#YourTempTable') IS NOT NULL

Note that in SQL Server thru...

WayneS (11/22/2010)

---

BTW, the best way to check for the existance of a temporary table in your current session is:

IF OBJECT_ID('tempdb..#YourTempTable') IS NOT NULL

Note that in SQL Server thru version 2008R2,...

That's true!

I ran it on sql2000 sp4.

vk-kirov (11/22/2010)

---

Carlo Romagnano (11/22/2010)

---

Also this is wrong:

You will see ALL tables that begins with '#testvm', also, tables belonging...

Also this is wrong:

You will see ALL tables that begins with '#testvm', also, tables belonging to other sessions.