[dba-SQLServer] SQL joins

Stephen Bond stephen at bondsoftware.co.nz
Tue Apr 8 19:54:08 CDT 2014


Darryl, my approach precisely.  And the graphic has been printed and is
on the wall.  Belt and braces.

Stephen Bond



-----Original Message-----
From: dba-sqlserver-bounces at databaseadvisors.com
[mailto:dba-sqlserver-bounces at databaseadvisors.com] On Behalf Of Darryl
Collins
Sent: Wednesday, 9 April 2014 11:15 a.m.
To: Stephen
Subject: Re: [dba-SQLServer] SQL joins

Yes, that is rather succinct and neat.  I tend to cheat when writing SQL
strings for SQL Server and just use the GUI Query Builder in Access and
then copy the SQL code from there.  90% of the time is will drop right
in, although there are occasionally minor syntax tweaks required.
Nothing a quick trip via Notepad 'search / replace' can't fix.  Amateur
hour perhaps, but then again, that is closer to my SQL Server skills
than 'DBA Guru' ;)

Cheers
Darryl.



-----Original Message-----
From: dba-sqlserver-bounces at databaseadvisors.com
[mailto:dba-sqlserver-bounces at databaseadvisors.com] On Behalf Of Jim
Lawrence
Sent: Tuesday, 8 April 2014 3:39 PM
To: Discussion concerning MS SQL Server
Subject: [dba-SQLServer] SQL joins

Hi All:

I have to anyways carefully think before doing any SQL statements but
with the following graphic it should be a snap.

https://twitter.com/ashalynd/status/449828745495330817/photo/1/large

Jim
_______________________________________________
dba-SQLServer mailing list
dba-SQLServer at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/dba-sqlserver
http://www.databaseadvisors.com


_______________________________________________
dba-SQLServer mailing list
dba-SQLServer at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/dba-sqlserver
http://www.databaseadvisors.com






More information about the dba-SQLServer mailing list