In this:

update table_A set column_A =

(select columnB from tableB

where tableA.codigo = tableB.codigo)

If there isn't a matching value in tableB, based on the codigo column in tableA, then that...

Are you checking the log for failed login attempts, or are you just assuming that there are none?

It looks like your query has hash marks where it should have periods and parentheses. Either that, or your using some version of SQL other than Microsoft's T-SQL.

When you...

There's a book, The Problems of Work, and a course based on it, The Personal Efficiency Course, that cover techniques for all of these things, and details on tested and...

I'm going to assume that you don't mean the new sequence number feature found in SQL Denali, since that hasn't been released yet.

That means you probably mean an Identity column...

Lynn Pettis (3/26/2011)

---

Okay, poll time. How many of you are getting tired of Celko and his high horse?

I may be wrong, but I think I could count on one...

Stefan Krzywicki (3/26/2011)

---

Jeff Moden (3/26/2011)

---

Gianluca Sartori (3/25/2011)

---

GilaMonster (3/25/2011)

---

I like that....

Edit:...

Here's what Microsoft has to say about the error number:

Error 18456

Topic last updated -- January 2004

Severity Level 14

Message Text

Login failed for user '%ls'.

Login failed for user distributor_admin.

Explanation

•If the...

In that case, don't do it in a trigger, unless the trigger is in a database that has absolutely no performance implications at all, and can deal with dropped transactions.

If...

Stefan Krzywicki (3/25/2011)

---

GSquared (3/25/2011)

---

Stefan Krzywicki (3/25/2011)

---

Oh wow. That'd be awesome for board games! Imagine playing Avalon Hill or SPI games (or World In Flames, etc...) on a map where...

http://support.microsoft.com/lifecycle/search/default.aspx?sort=PN&alpha=sql+server+2005&Filter=FilterNO

As FOSS databases get more features, MS will have to start looking into something like this. What they'll do, I don't know. If they follow the usual MS...

Stefan Krzywicki (3/25/2011)

---

Oh wow. That'd be awesome for board games! Imagine playing Avalon Hill or SPI games (or World In Flames, etc...) on a map where you can shift...

Stefan Krzywicki (3/25/2011)

---

jcrawf02 (3/25/2011)

---

Stefan Krzywicki (3/25/2011)

---

GSquared (3/25/2011)

---

jcrawf02 (3/25/2011)

---

GSquared (3/25/2011)

---

So start a completely serious post with, "I...

I'd still stick the join table method, even if you assume the codes will be static for the rest of eternity. It's a better design practice, and easier to...