Examples of basic query in SQL Server

OBJECTIVE

In this chapter you will learn:

Basic examples of sql server
Exercise

Basic example

Output

 

query 1 output
 

Exercises

  1. View the all records from HumanResources.Employee table in AdventureWorks database.
  2. Show the person address from the AdventureWorks database.

 

SUMMARY

In this chapter you have learned how to view all records from any specific table of the database. In the next session you will learn about data types in sql.


Leave a Reply

Your email address will not be published. Required fields are marked *