Flashcards
MS SQL
Flashcards do conjunto (9)
- 1Get a list of all databasesSELECT *
FROM master.dbo.sysdatabases - 2Get a list of all tablesSELECT
*
FROM
SYSOBJECTS
WHERE
xtype = 'U' - 3Get a list of all tables (alternative way)SELECT
*
FROM
INFORMATION_SCHEMA.TABLES - 4Get a list a description of a particular table all columnsEXEC sp_columns [table name]
- 5Show the current used database nameSELECT db_name()
- 6Access databaseUSE [database name]
- 7Get the top 100 rows of a particular tableSELECT TOP (100) [columns names list]
FROM [table name] - 8Enforce case sensitive selectSELECT [first_name]
FROM [table name]
WHERE BINARY [first_name] = 'First Person' - 9Assign ALIAS to a column original nameSELECT [first_name] AS 'Name'
FROM [table name]
Informações
- Descrição
- Programming FlashCards sobre MS SQL, criado por Magdoulin Shams El-Din em 21-09-2022.
- Criado por
- Magdoulin Shams El-Din
- Visualizações
- 0
- Avaliação