A repo of examples of connecting to SQL in different ways from R.
a) Will we do the data manipulations in R environment or SQL environment? b) Will we save our output in SQL or elsewhere?
I want to know which month in MODELLING_SQL_AREA.dbo.New_Cambridge_Score had the most men aged 30-43. What's the best code to answer that (admittedly dull) question?