How to query data from table of adventureworks2012 database

How to query data from table of adventureworks2012 database plus#

Querying data out of a single table is a rare event. These queries work fine when we only need data out of a single table. To do so, letвЂ™s use the following query, вЂњSELECT Name, GroupName FROM HumanResources.Department WHERE GroupName = вЂExecutive General and AdministrationвЂќ. LetвЂ™s suppose we need the Departments under Executive General and Administration. To return precisely the number of rows you need, we will need use the WHERE clause in our query. In general, it just follows from a good principle of living, take only what you need and no more. ThereвЂ™s a lot of reasons for this, sometimes from a managing data perspective, other times from a server load perspective. Of course, itвЂ™s also best practice to only return the rows you need as well.

To do so letвЂ™s type, вЂњSELECT Name, GroupName FROM HumanResources.DepartmentвЂќ. For example, letвЂ™s just return the Name and GroupName. ItвЂ™s best practice to return only the columns you need. We can do this by typing out in the new query window, вЂњSELECT * FROM HumanResources.DepartmentвЂќ. LetвЂ™s start by just returning all rows and all columns from with HumanResources.Department. Right click on AdventureWorks2008RS and select, вЂњNew QueryвЂќ. We can assume that this table models departments and divisions inside of the AdventureWorks organization. At that point, just type in вЂњConstraintsвЂќ, and youвЂ™ll find an entry constraints in the section on understanding tables. You may find the BOL entry by clicking, вЂњHelpвЂќ inside of SSMS and clicking, вЂњsearchвЂќ. Constraints are quite important in databases, you can learn about them more here as well as in Books Online (BOL), the help built into SQL Server Management Studio (SSMS). In addition, we have a default constraint on the ModifiedDate column. In the above picture, we can observe that we have four columns titled, вЂњDepartmentIDвЂќ, вЂњNameвЂќ, вЂњGroupNameвЂќ, and, вЂњModifiedDateвЂќ. The two features youвЂ™re likely to be most interested to start with are columns and constraints. If you expand a table, say HumanResources.Department, you find features that are appropriate to tables contained within. I have to assume some basic level of acquaintance with databases, but succinctly put, tables are to databases what tracks are to CDs (I wonder how long that analogy will last). YouвЂ™ll see a number of tables within the database.

How to query data from table of adventureworks2012 database plus#

Click the plus sign next to AdventureWorks2008R2. LetвЂ™s take a moment to explore our surroundings a little bit. Upon successful install, we were able to connect to our database server and expand the installed databases. In a previous post, we walked through installing SQL Server 2008 and the Adventure Works databases.