There is a simple way to return information from all the columns in SQL. SELECT * FROM INSERTTABLENAME For example SELECT * FROM HumanResources.Department As you can see the query returned 16 rows of information with all the columns.
Before you can start querying a database you will need to select the database first. This is done using the USE command USE Enteryourdatabasenamehere For example USE AdventureWorks This will change the queried database to AdventureWorks
In a time-honoured tradition in every programming language the first thing they teach you is how to get the system to put ‘Hello World’ on to your screen. This is accomplished by using the below command. PRINT ‘HELLO WORLD’ Play about with the PRINT command and see what else you can get the system to […]