Viewing 15 posts - 4,486 through 4,500 (of 14,953 total)
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...
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
March 28, 2011 at 9:26 am
Are you checking the log for failed login attempts, or are you just assuming that there are none?
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
March 28, 2011 at 9:19 am
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...
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
March 28, 2011 at 9:17 am
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...
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
March 28, 2011 at 9:13 am
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...
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
March 28, 2011 at 6:28 am
Lynn Pettis (3/26/2011)
I may be wrong, but I think I could count on one...
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
March 28, 2011 at 6:20 am
Stefan Krzywicki (3/26/2011)
Jeff Moden (3/26/2011)
Gianluca Sartori (3/25/2011)
GilaMonster (3/25/2011)
Koen Verbeeck (3/25/2011)
Maybe a blog post that Microsoft has purchased MySQL from Oracle and that it is integrating it with SQLServer.\
I like that....
Edit:...
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
March 28, 2011 at 6:15 am
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...
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
March 25, 2011 at 12:11 pm
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...
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
March 25, 2011 at 11:27 am
Stefan Krzywicki (3/25/2011)
GSquared (3/25/2011)
Stefan Krzywicki (3/25/2011)
GSquared (3/25/2011)http://www.microsoft.com/surface/
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...
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
March 25, 2011 at 10:58 am
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
March 25, 2011 at 10:51 am
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...
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
March 25, 2011 at 10:46 am
Stefan Krzywicki (3/25/2011)
GSquared (3/25/2011)http://www.microsoft.com/surface/
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...
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
March 25, 2011 at 10:33 am
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)
GilaMonster (3/25/2011)
I just realised I don't have an April Fools day blog post planned. 🙁
So start a completely serious post with, "I...
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
March 25, 2011 at 10:05 am
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...
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
March 25, 2011 at 10:03 am
Viewing 15 posts - 4,486 through 4,500 (of 14,953 total)