Examples of basic query in SQL Server

In this chapter you will learn:
Basic examples of sql server
Exercise

Basic example

select * from HumanResources.Department

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.

More Articles

 

Share your thought



PLEASE DISABLE ADBLOCKER AND SUPPORT US!

Please support us by enabling ads on this page. Refresh

YOU DON'T LIKE ADS, WE ALSO DON'T LIKE ADS!
 
But we have to show ads on our site to keep it free and updated. We have to pay huge server costs, domain costs, CDN Costs, Developer Costs, Electricity and Internet Bill. Your little contribution will encourage us to regularly update this site.