Steve Slaughter (7/13/2009)

---

Personally I think it is a stretch to put all of it into one large database. It will make the client backups, which some clients request, not doable...

Books Online 2008

---

Using SET ROWCOUNT will not affect DELETE, INSERT, and UPDATE statements in the next release of SQL Server. Avoid using SET ROWCOUNT with DELETE, INSERT, and UPDATE statements...

You can't use WITH SCHEMABINDING on a view that references system objects, as you have discovered.

There is often a way around this though. In your case, all you need...

I think my 486 DX2/66 had a turbo button - if I recall it ran at 33Mhz normally...

That query is easy:

SELECT

FROM

WHERE tatcalltype = 'null'

AND

OPTION...

Awesome Flo!

Jack Corbett (7/13/2009)

---

Grant Fritchey (7/13/2009)

---

jcrawf02 (7/13/2009)

---

...then he should use...

You're welcome 🙂

But only if you use little letters (less aerodynamic drag = faster!)

Oh Lordy. I just found the full line:

update Auditdata set tatcalltype = 'null' where tatcalltype is null

:sick:

Gaby Abed (7/13/2009)

---

...a whole bunch of people...create triggers on the fly...forget to commit transactions...more serious issues involved beyond the scope of the database...only the DBA's should have the authority to...

Florian Reischl (7/13/2009)

---

VB6 is way back for me... As I remember "Nothing" was equivalent to "null" which only worked for complex data types (not Integer, String, ...). Working with optional...

RBarryYoung (7/12/2009)

---

Now back in the old VB, you could specify optional parameters without having to also specify a default (in fact originally you couldn't specify defaults at all). You...

I posted that script in response to your first of your two recent posts (I process stuff in email-notification order!), but I think it broadly covers the questions in your...

cb,

Hopefully, this demo script will illustrate the method I was trying to describe before:

As far as I know, there is no really easy of convenient way to do this, though...

That's odd - I was just wondering the same thing,...