Category: Learning SQL
-
Understanding DELETE Statements
After you are comfortable with selecting information and isolating it, I would then recommend moving on to DELETE statements. You must be cautious when running a delete statement as this will remove data from your system. Because you will be making a change to your data, I always recommend getting into the practice of creating…
-
Understanding the SQL Query Window
Knowing where to look to run a query is also extremely helpful to getting started. There are three locations within SQL Server that you need to be aware of to get started. You can select New Query and this will bring up a new window to type your SQL query. You will see a box…
-
SQL Saturday
Learning SQL and becoming involved in the technical community can be difficult if you do not know where to look. A fantastic event that encourages people of all ability levels is through PASS. PASS is an independent, not-for-profit organization run by and for the community. One event that they offer for each of their communities…
-
Understanding SELECT Statements
The first time anyone looks at SQL can be overwhelming. Mostly because it is like learning a foreign language. You need to learn the vocabulary and the syntax to get what you want. The first step to learning should be how to navigate information. In my examples, I will be using examples from Microsoft Dynamics…
-
Top 5 SQL Tips for Microsoft Dynamic GP
Think necessity – Only look for the information you really need. The fewer rows that you pull in the quicker your query will be. Keep it simple stupid (KISS) – When you attempt to get fancy with the queries, it can have consequences. Meaning that the queries can take longer and pull unnecessary data. Overcomplicating…
-
Understanding SQL Tables 101
There are many concepts that are brushed aside as extremely basic. This post is going to be for someone that does not know anything about SQL and may seem overly basic to anyone that already knows about databases. This is the first post in a series and will address database structure. After speaking with several…