Viewing 15 posts - 571 through 585 (of 1,189 total)
batgirl (9/11/2013)
Ross.M (9/11/2013)
raulggonzalez (9/11/2013)
making a research is usually what I do when I don't know the answer for sure. Copy/paste+F5 and select the right answer is cheating, period. 😀
Though...
-------------------
A SQL query walks into a bar and sees two tables. He walks up to them and asks, "Can I join you?"
Ref.: http://tkyte.blogspot.com/2009/02/sql-joke.html
September 11, 2013 at 10:19 am
Great question idea, problem in the execution.
I got it right by choosing 2, but sadly if there is a string truncation error and the results returned are 0 with the...
-------------------
A SQL query walks into a bar and sees two tables. He walks up to them and asks, "Can I join you?"
Ref.: http://tkyte.blogspot.com/2009/02/sql-joke.html
September 11, 2013 at 9:59 am
Robert-378556 (9/4/2013)
webrunner (9/3/2013)
-------------------
A SQL query walks into a bar and sees two tables. He walks up to them and asks, "Can I join you?"
Ref.: http://tkyte.blogspot.com/2009/02/sql-joke.html
September 4, 2013 at 8:14 am
webrunner (9/3/2013)
The question has 'dsh' and the explanation has 'dhs' - which is it?
Never mind. It is 'dsh' as in 'commandshell'.
🙂
-------------------
A SQL query walks into a bar and sees two tables. He walks up to them and asks, "Can I join you?"
Ref.: http://tkyte.blogspot.com/2009/02/sql-joke.html
September 3, 2013 at 2:59 pm
The question has 'dsh' and the explanation has 'dhs' - which is it?
-------------------
A SQL query walks into a bar and sees two tables. He walks up to them and asks, "Can I join you?"
Ref.: http://tkyte.blogspot.com/2009/02/sql-joke.html
September 3, 2013 at 2:58 pm
Fascinating idea. Does anyone have any suggestions for sites or books that discuss how to integrate a sensor and a SQL database? Sounds like that would be fun to try.
Thanks,
webrunner
-------------------
A SQL query walks into a bar and sees two tables. He walks up to them and asks, "Can I join you?"
Ref.: http://tkyte.blogspot.com/2009/02/sql-joke.html
September 3, 2013 at 2:29 pm
Jamie Ingram-729524 (8/28/2013)
You can populate as many tables as you want with data and just use cartesian joins to give the bulk.
I have...
-------------------
A SQL query walks into a bar and sees two tables. He walks up to them and asks, "Can I join you?"
Ref.: http://tkyte.blogspot.com/2009/02/sql-joke.html
August 29, 2013 at 8:40 am
Yes, that is usually the challenge. Especially a lot of repeats of the same dummy data.
Perhaps an idea would be to have a framework, and depending on what data...
-------------------
A SQL query walks into a bar and sees two tables. He walks up to them and asks, "Can I join you?"
Ref.: http://tkyte.blogspot.com/2009/02/sql-joke.html
August 28, 2013 at 7:45 am
Great reply, Jeff. I wondered the same things (low number of stars, hard-coded data), but think this is a great topic and I applaud the author for taking a crack...
-------------------
A SQL query walks into a bar and sees two tables. He walks up to them and asks, "Can I join you?"
Ref.: http://tkyte.blogspot.com/2009/02/sql-joke.html
August 27, 2013 at 2:11 pm
Thanks once more, Scott.
I did realize the INSTEAD OF trigger would cancel the original delete that was issued 🙂 but didn't realize the care needed in using ROLLBACK or in...
-------------------
A SQL query walks into a bar and sees two tables. He walks up to them and asks, "Can I join you?"
Ref.: http://tkyte.blogspot.com/2009/02/sql-joke.html
July 25, 2013 at 2:06 pm
Thanks, Scott,
By "prevents the actual statement from running" do you mean the original DELETE statement? And then any code in the trigger after the ROLLBACK does get run? That would...
-------------------
A SQL query walks into a bar and sees two tables. He walks up to them and asks, "Can I join you?"
Ref.: http://tkyte.blogspot.com/2009/02/sql-joke.html
July 25, 2013 at 10:06 am
Thanks, Eugene, I see. I had commented out the ROLLBACK for my INSTEAD OF trigger so didn't understand the behavior you just posted with the test code. Perhaps Scott was...
-------------------
A SQL query walks into a bar and sees two tables. He walks up to them and asks, "Can I join you?"
Ref.: http://tkyte.blogspot.com/2009/02/sql-joke.html
July 25, 2013 at 8:52 am
Eugene Elutin (7/25/2013)
webrunner (7/25/2013)
ScottPletcher (7/24/2013)
webrunner (7/24/2013)
Alexander Suprun (7/24/2013)
-------------------
A SQL query walks into a bar and sees two tables. He walks up to them and asks, "Can I join you?"
Ref.: http://tkyte.blogspot.com/2009/02/sql-joke.html
July 25, 2013 at 8:20 am
ScottPletcher (7/24/2013)
webrunner (7/24/2013)
Alexander Suprun (7/24/2013)
-------------------
A SQL query walks into a bar and sees two tables. He walks up to them and asks, "Can I join you?"
Ref.: http://tkyte.blogspot.com/2009/02/sql-joke.html
July 25, 2013 at 8:01 am
Alexander Suprun (7/24/2013)
-------------------
A SQL query walks into a bar and sees two tables. He walks up to them and asks, "Can I join you?"
Ref.: http://tkyte.blogspot.com/2009/02/sql-joke.html
July 24, 2013 at 3:01 pm
Viewing 15 posts - 571 through 585 (of 1,189 total)