A small Twist in career
-
Repeat after me:
SELECT * FROM
someting AS st INNER JOIN
somethingelse AS se ON se.SomethingId = st.IdShirley this already brought it all back, right? :-)
I have lived with several Zen masters - all of them were cats.
Arrrgh! NOOOOO!
SELECT st.TingOne, st.TingTwo, se.TingThree FROM
someting AS st INNER JOIN
somethingelse AS se ON se.SomethingId = st.Id:laugh:
Bad command or file name. Bad, bad command! Sit! Stay! Staaaay... AntiTwitter: @DalekDave is now a follower!
-
As a never ending twist and turns in my career, I have been asked to work on Sql queries ( only Select to populate data and copy in excel). I worked on it like 15 years back and never touched sql script. So any links or online resource to brush up my memory?
cheers,
Super
------------------------------------------ Too much of good is bad,mix some evil in it
W3Schools cover it all, but can be a bit "brick wall" from time to time. This is OK: SQL Tutorial - Learn SQL Query Programming Language[^] And there are some very handy bits added in the last 15 years such as LEAD and LAG which give you access to the next and previous row in a dataset.
Bad command or file name. Bad, bad command! Sit! Stay! Staaaay... AntiTwitter: @DalekDave is now a follower!
-
W3Schools cover it all, but can be a bit "brick wall" from time to time. This is OK: SQL Tutorial - Learn SQL Query Programming Language[^] And there are some very handy bits added in the last 15 years such as LEAD and LAG which give you access to the next and previous row in a dataset.
Bad command or file name. Bad, bad command! Sit! Stay! Staaaay... AntiTwitter: @DalekDave is now a follower!
OriginalGriff wrote:
And there are some very handy bits added in the last 15 years such as LEAD and LAG
be careful though, some people haven't upgraded for even longer, others, dare I say it, use access
Installing Signature... Do not switch off your computer.
-
OriginalGriff wrote:
And there are some very handy bits added in the last 15 years such as LEAD and LAG
be careful though, some people haven't upgraded for even longer, others, dare I say it, use access
Installing Signature... Do not switch off your computer.
-
Eddy Vluggen wrote:
ome of us happen to like the SQL92 standard, as it is available for most databases. Makes your queries a bit more portable :)
yup, I'm one of those too, standard, portable, readable. ...in fact didn't know what LEAD and LAG was till OG mentioned it in this thread - had to google it, and 90% of my work involves SQL databases - a lot lately on FireBird 1.5 which is old, has almost no extensions, but it is SQL92, and that's all that matters.
Installing Signature... Do not switch off your computer.
-
As a never ending twist and turns in my career, I have been asked to work on Sql queries ( only Select to populate data and copy in excel). I worked on it like 15 years back and never touched sql script. So any links or online resource to brush up my memory?
cheers,
Super
------------------------------------------ Too much of good is bad,mix some evil in it
-
As a never ending twist and turns in my career, I have been asked to work on Sql queries ( only Select to populate data and copy in excel). I worked on it like 15 years back and never touched sql script. So any links or online resource to brush up my memory?
cheers,
Super
------------------------------------------ Too much of good is bad,mix some evil in it
Assuming SQL Server, SQL Server Tutorial[^]
Wrong is evil and must be defeated. - Jeff Ello
-
Eddy Vluggen wrote:
ome of us happen to like the SQL92 standard, as it is available for most databases. Makes your queries a bit more portable :)
yup, I'm one of those too, standard, portable, readable. ...in fact didn't know what LEAD and LAG was till OG mentioned it in this thread - had to google it, and 90% of my work involves SQL databases - a lot lately on FireBird 1.5 which is old, has almost no extensions, but it is SQL92, and that's all that matters.
Installing Signature... Do not switch off your computer.
Lopatir wrote:
yup, I'm one of those too, standard, portable, readable.
Not as sexy as the cloud, but plain and boring - which is a good thing sometimes :)
Lopatir wrote:
it is SQL92, and that's all that matters
Not all, but most; if you're programming directly against a specific database-provider you'd still have a lot of database-specific code. If you program against the interfaces and you use SQL92, then changing the type of database should not be much of a problem. In that case, any database that has a database-provider in .NET and is SQL92-compliant will work. It's the difference between telling the customer that you use "database X, version Y" and telling the customer "any SQL92 DB you like or have".
Bastard Programmer from Hell :suss: If you can't read my code, try converting it here[^]
-
Eddy Vluggen wrote:
ome of us happen to like the SQL92 standard, as it is available for most databases. Makes your queries a bit more portable :)
yup, I'm one of those too, standard, portable, readable. ...in fact didn't know what LEAD and LAG was till OG mentioned it in this thread - had to google it, and 90% of my work involves SQL databases - a lot lately on FireBird 1.5 which is old, has almost no extensions, but it is SQL92, and that's all that matters.
Installing Signature... Do not switch off your computer.
I don't worry too much about portable - I just make sure I develop using the same version of SQL as the target production system: so currently SQL 2012 SP1.
Bad command or file name. Bad, bad command! Sit! Stay! Staaaay... AntiTwitter: @DalekDave is now a follower!
-
I don't worry too much about portable - I just make sure I develop using the same version of SQL as the target production system: so currently SQL 2012 SP1.
Bad command or file name. Bad, bad command! Sit! Stay! Staaaay... AntiTwitter: @DalekDave is now a follower!
It is hardly a worry; but as good as MSSQL 2012 is, it still is a vendor lock in. Not a vendor that is likely to go bankrupt, but stranger things have happened. For using a bit less fewer new features, you get flexibility in return.
Bastard Programmer from Hell :suss: If you can't read my code, try converting it here[^]
-
It is hardly a worry; but as good as MSSQL 2012 is, it still is a vendor lock in. Not a vendor that is likely to go bankrupt, but stranger things have happened. For using a bit less fewer new features, you get flexibility in return.
Bastard Programmer from Hell :suss: If you can't read my code, try converting it here[^]
This is true, but ... even if MS went bust tomorrow, SQL server will keep on working - and there would be much more pressing matters than replacing it in a hurry! :laugh:
Bad command or file name. Bad, bad command! Sit! Stay! Staaaay... AntiTwitter: @DalekDave is now a follower!
-
As a never ending twist and turns in my career, I have been asked to work on Sql queries ( only Select to populate data and copy in excel). I worked on it like 15 years back and never touched sql script. So any links or online resource to brush up my memory?
cheers,
Super
------------------------------------------ Too much of good is bad,mix some evil in it
-
This is true, but ... even if MS went bust tomorrow, SQL server will keep on working - and there would be much more pressing matters than replacing it in a hurry! :laugh:
Bad command or file name. Bad, bad command! Sit! Stay! Staaaay... AntiTwitter: @DalekDave is now a follower!
it's not so much ms going bust as compared to if they keep doing what they do... they do have a history of changing the way things work, for instance ie, once upon a time css had to test for ff vs ie, but then ms upped the ante by changing their own difference, so then there were tests not only for ie, but which version of ie. What this means if you use their non standard features: you've put a bunch of code out to clients, along comes a new version of whatever you're using from ms, some clients upgrade, some don't - your code breaks in some places but not others. in fact it'd almost be a good thing if ms went bust, at least they would no longer be changing stuff depending on which way nads farts are blowing, including still breaking their own staff regardless it works or not.
Installing Signature... Do not switch off your computer.
-
As a never ending twist and turns in my career, I have been asked to work on Sql queries ( only Select to populate data and copy in excel). I worked on it like 15 years back and never touched sql script. So any links or online resource to brush up my memory?
cheers,
Super
------------------------------------------ Too much of good is bad,mix some evil in it
-
As a never ending twist and turns in my career, I have been asked to work on Sql queries ( only Select to populate data and copy in excel). I worked on it like 15 years back and never touched sql script. So any links or online resource to brush up my memory?
cheers,
Super
------------------------------------------ Too much of good is bad,mix some evil in it
In general SQL Server Central [^] no matter what your expertise / level. They have a log of good 'stairways' you can start with the Stairway to T-SQL DML – a SQL Server tutorial[^] DML == Data Manipulation Language (the aspect of the language dealing with the data: SELECT, INSERT, UPDATE and DELETE) I'd recommend you review all of DML, not just select... but that's my opinion. HTH, -Chris C.
