Fichas
MS SQL
Fichas del 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]
Información
- Descripción
- Programming Fichas sobre MS SQL, creado por Magdoulin Shams El-Din el 21/09/2022.
- Creado por
- Magdoulin Shams El-Din
- Visitas
- 0
- Valoración