Azure SQL
1 page views
0 video views
2024, August 09, Friday

#005 Return all rows and columns in Azure SQL

Como retornar todas as linhas e todas as colunas em Consulta (SELECT) existente na linguagem de Manipulação de Dados (DML) do Azure SQL/SQL Server #microsoft #dataplataform #dataanalyst #sqlserver #azure #sql #database #DicaDoFabinho

This T-SQL code performs a simple query on the "erp. Collaborators". I'll explain each

part of the code:SELECT

*:SELECT
- : Indicates that the next part of the code will specify which columns will be returned in the query.
- *: An asterisk is used as a wildcard meaning "all columns". Therefore, this part of the code requests that all columns in the table be returned in the query.
FROM erp. Collaborators
:
- FROM: Indicates the table from which the data will be selected.
- erp. Collaborators: This is the name of the table from which the data will be extracted. The prefix "erp." suggests that the table is in a schema called "erp."

Therefore, the query returns all columns from all records in the "erp. Collaborators". This type of query is useful when you want to get an overview of all the data present in the table without the need to specify specific columns.