[AccessD] SQL server learning

Thanks Darryl. It is a miasma bout to trigger me asthma.
On Jun 30, 2014 1:03 AM, "Darryl Collins" <darryl at whittleconsulting.com.au>
wrote:

> Hi Bill,
>
>  - Tables are Tables,
>  - Views are like Queries, but be aware a view alone does not honour the
> "ORDER BY" - you need to specify that when you call the view
>
>         Ie:
>         SELECT * FROM vMyView
>         ORDER BY Blah
>
> Stored Procedures are like Action Queries and/or VBA Code Modules.  They
> are basically packages of pre-formed code that you call.
>
> One fast and easy way to create views or even Sprocs is to use MS Access's
> own GUI query builder and copy the SQL code from there into the Code window
> for the view.
>
> Sometimes you will need to go view Notepad (or similar) to clean up the
> text - much of it you can drop right in, but there are some syntax
> differences between SQL Server and Access with SQL code.
>
> Anyway.  That is a 10 second place to start.
>
> Cheers
> Darryl.
>
>
>
>
> -----Original Message-----
> From: accessd-bounces at databaseadvisors.com [mailto:
> accessd-bounces at databaseadvisors.com] On Behalf Of Bill Benson
> Sent: Monday, 30 June 2014 2:29 PM
> To: Access Developers discussion and problem solving
> Subject: [AccessD] SQL server learning
>
> I finally have SQL server 2012 installed and am starting to learn a little
> about SQL server management studio. I have not seen much T-SQL before so
> watching all these complex scripts get written and dumped to the query
> editor as I do things is pretty intimidating.
>
> I thought I could cut my learning curve a bit by downloading the
> AdventureWorks database. But that is a pretty sophisticated animal,  at
> least in 2012 and later.
>
> I think I have to take a step back and ask myself what I am trying to
> learn. Telling myself I am trying to learn SQL server is a bit nebulous and
> overly ambitious.
>
> But when a job description says experience with SSRS and SSIS a plus ...
> And I want the job... I want to at least demonstrate I can do something.
>
> In case you are wondering if there is a question here... Not really. I
> feel too I whelmed to even ask a question.
>
> Aye aye AYE.
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>