[AccessD] SQL server learning

Darryl Collins darryl at whittleconsulting.com.au
Mon Jun 30 00:02:35 CDT 2014


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



More information about the AccessD mailing list