Help & FAQs    Search BCF    Members    Groups    Events Calendar
Resend my activation email : Register : Log in 
BCF: Bike Chat Forums


SQL Clause

 Reply to topic
Bike Chat Forums Index -> The Geek Zone
View previous topic : View next topic  
Author Message

goto10
World Chat Champion



Joined: 16 Oct 2011
Karma :
PostPosted: 10:45 - 08 Dec 2016    Post subject: SQL Clause Reply with quote
https://twitter.com/leeflower/status/806533901124599808

He's making a list
He's testing it twice
SELECT * FROM users WHERE behavior="nice"
SQL-clause is coming
To town.
____________________
'12 NC700S & '12 CB600F Hornet [Stolen by some dickless twat] Suzuki GT500 shed
 Back to top
View user's profile Send private message You must be logged in to rate posts

Andy_Pagin
World Chat Champion



Joined: 08 Nov 2010
Karma :
PostPosted: 13:00 - 08 Dec 2016    Post subject: Reply with quote
goto10

10 exit
____________________
They're coming to take me away, ho-ho, hee-hee, ha-haaa, hey-hey,
the men in white coats are coming to take me away.
Yamaha Vity -> YBR125 -> FZS600 Fazer -> FZ1-S Fazer
 Back to top
View user's profile Send private message Send e-mail You must be logged in to rate posts

supZ
World Chat Champion



Joined: 03 Feb 2009
Karma :
PostPosted: 15:43 - 08 Dec 2016    Post subject: Reply with quote
The developer in me is screaming about the incorrect syntax of using " instead of '

#nerd
____________________
CBR954RR - Daily toy
CBR600RR - Trackbike
 Back to top
View user's profile Send private message You must be logged in to rate posts

Andy_Pagin
World Chat Champion



Joined: 08 Nov 2010
Karma :
PostPosted: 16:11 - 08 Dec 2016    Post subject: Reply with quote
Should be...

He's populating a table
He's verifying it twice
SELECT * FROM table WHERE behavior="nice"
SQL-clause is coming
To town.

#nerd++
____________________
They're coming to take me away, ho-ho, hee-hee, ha-haaa, hey-hey,
the men in white coats are coming to take me away.
Yamaha Vity -> YBR125 -> FZS600 Fazer -> FZ1-S Fazer
 Back to top
View user's profile Send private message Send e-mail You must be logged in to rate posts

supZ
World Chat Champion



Joined: 03 Feb 2009
Karma :
PostPosted: 16:22 - 08 Dec 2016    Post subject: Reply with quote
Oh to ultra nerd my version would be..

He's populating a table
He's indexing it twice
SELECT childid, name, location FROM table WHERE nice = 1
SQL-clause is coming
To town.

# As of course a numeric/bit clause is far more efficient than string matching.

Christmas Hat
____________________
CBR954RR - Daily toy
CBR600RR - Trackbike
 Back to top
View user's profile Send private message You must be logged in to rate posts

Andy_Pagin
World Chat Champion



Joined: 08 Nov 2010
Karma :
PostPosted: 16:35 - 08 Dec 2016    Post subject: Reply with quote
supZ wrote:
Oh to ultra nerd my version would be..

He's populating a table
He's indexing it twice
SELECT childid, name, location FROM table WHERE nice = 1
SQL-clause is coming
To town.

# As of course a numeric/bit clause is far more efficient than string matching.

Christmas Hat


You're confusing internal database engine processes with data entry. 'Checking it twice' implies the practice of one data entry clerks' input being verified against an identical entry from another clerk. I'm assuming Santa takes a managerial role in this business area and the actual data entry is carried out by suitably trained Elves.

I know this is a bit old school, but then every image you see of Santas' workshop show dated construction practices. I suspect they're still running an ICL2988 (or even 1900 Shocked ).

#BusinessAnalystNerd
____________________
They're coming to take me away, ho-ho, hee-hee, ha-haaa, hey-hey,
the men in white coats are coming to take me away.
Yamaha Vity -> YBR125 -> FZS600 Fazer -> FZ1-S Fazer
 Back to top
View user's profile Send private message Send e-mail You must be logged in to rate posts

J.M.
World Chat Champion



Joined: 27 Mar 2011
Karma :
PostPosted: 00:05 - 09 Dec 2016    Post subject: Reply with quote
Code:
DROP TABLE users


If only Christmas was so easy
____________________
2004 R1 & 2018 XSR900
 Back to top
View user's profile Send private message You must be logged in to rate posts

wots
World Chat Champion



Joined: 30 Aug 2012
Karma :
PostPosted: 09:31 - 09 Dec 2016    Post subject: Reply with quote
A senior DBA sent me this, just to take it up a notch

Needs running in a query window, but safe to run.

Code:
DECLARE @strArchive VARCHAR(511),
@strEmail VARCHAR(511),
@strSMS VARCHAR(511),
@strCountry VARCHAR(511),
@strCounty VARCHAR(511),
@strDebug VARCHAR(511),
@strEmailSupport VARCHAR(511),
@strForgottenPassword VARCHAR(511),
@strPassword VARCHAR(511),
@strBranch VARCHAR(511),
@strBranches VARCHAR(511),
@strHappy VARCHAR(511),
@strHappy2 VARCHAR(511),
@strISO_636 VARCHAR(511),
@strJobPosting VARCHAR(511),
@strLanguage VARCHAR(511) ,
@strGender VARCHAR(511)         
         

SET @strHappy2 = ' @@   @@ @@                          @@'
SET @strEmail = '   @@@   @@   @@ @@       @@ @@@@     @@   @@       @@  @@@@ @@ @@@@'
SET @strBranches ='             @@    @@    @@   @@@@  @@      @@         @@'         
SET @strJobPosting = '               @@          @@'
SET @strBranch = '             @@@        @@@'
SET @strDebug = '             @@ @@    @@ @@  @@  @@ @@@  @@ @@@  @@ @@    @@'

SET @strSMS = '             @@   @@@@   @@  @@     @@      @@        @@@@'
SET @strEmailSupport = '@@       @@   @@ @@      @@   @@@    @@    @@   @@  @@ @@   @@   @@@'
SET @strPassword = '                                                  @@  @@'
SET @strGender = '   @@@   @@              @@          @@            @@@@'
SET @strArchive = '@@       @@ @@@  @@ @@@  @@   @@@@ @@@@@@  @@ @@  @@      @@@    @@@@'
SET @strISO_636 = '             @@@@      @@@@   @@@@  @@ @@@  @@ @@@ @@      @@'
SET @strCountry = '@@       @@@  @@ @@@  @@ @@  @@      @@    @@@  @@  @@  @@  @@  @@'
SET @strCounty = '         @@ @@@  @@   @@@@ @@@@@@  @@ @@  @@      @@@    @@@@'
SET @strLanguage = ' @@   @@ @@   @@ @@      @@     @@   @@ @@ @@       @@ @@   @@     @@'
SET @strHappy = '             @@  @@  @@  @@ @@@@@@  @@      @@       @@  @@'
         
PRINT @strJobPosting
PRINT @strBranch
PRINT @strISO_636
PRINT @strDebug
PRINT @strHappy
PRINT @strSMS
PRINT @strBranches
PRINT @strPassword
PRINT @strGender
PRINT @strHappy2
PRINT @strArchive
PRINT @strCountry
PRINT @strEmailSupport
PRINT @strLanguage
PRINT @strEmail

____________________
Currently: Yamaha DT 125 LC2,Repsol Fireblade, and Bumblebee MSX 125
 Back to top
View user's profile Send private message You must be logged in to rate posts

Andy_Pagin
World Chat Champion



Joined: 08 Nov 2010
Karma :
PostPosted: 09:43 - 09 Dec 2016    Post subject: Reply with quote
In the good old days (CP/M) this discussion would have ended up with Z80-A machine code.
____________________
They're coming to take me away, ho-ho, hee-hee, ha-haaa, hey-hey,
the men in white coats are coming to take me away.
Yamaha Vity -> YBR125 -> FZS600 Fazer -> FZ1-S Fazer
 Back to top
View user's profile Send private message Send e-mail You must be logged in to rate posts

Tigerlea
Nitrous Nuisance



Joined: 07 Jul 2016
Karma :
PostPosted: 13:21 - 12 Dec 2016    Post subject: Reply with quote
Personally I think it would be:

He's populating a table
He's verifying it twice
SELECT name, location, behaviour FROM table_children
SQL-clause is coming
To town.



With the elves, of course, doing the data entry on his behalf.
 Back to top
View user's profile Send private message You must be logged in to rate posts

Tigerlea
Nitrous Nuisance



Joined: 07 Jul 2016
Karma :
PostPosted: 13:24 - 12 Dec 2016    Post subject: Reply with quote
He would also probably GROUP BY country>region>address, too...
 Back to top
View user's profile Send private message You must be logged in to rate posts
Old Thread Alert!

The last post was made 8 years, 256 days ago. Instead of replying here, would creating a new thread be more useful?
  Display posts from previous:   
This page may contain affiliate links, which means we may earn a small commission if a visitor clicks through and makes a purchase. By clicking on an affiliate link, you accept that third-party cookies will be set.

Post new topic   Reply to topic    Bike Chat Forums Index -> The Geek Zone All times are GMT
Page 1 of 1

 
 You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
You cannot attach files in this forum
You cannot download files in this forum

Read the Terms of Use! - Powered by phpBB © phpBB Group
 
Debug Mode: ON - Server: birks (www) - Page Generation Time: 0.05 Sec - Server Load: 1.65 - MySQL Queries: 14 - Page Size: 73.56 Kb