Karteikarten
MS SQL
Karten in diesem Stapel (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]
Informationen
- Beschreibung
- Programming Karteikarten am MS SQL, erstellt von Magdoulin Shams El-Din am 21/09/2022.
- Erstellt von
- Magdoulin Shams El-Din
- Aufrufe
- 0
- Bewertung