Microsoft SQL Server
Metadata
View the service name and account
SELECT servicename, service_account
FROM sys.dm_server_services
GO
Syntax
Creating Indexes[1]
Create a unique index
CREATE UNIQUE INDEX idx_tablename_columnname ON tablename (columnname);
Create a clustered index
CREATE UNIQUE INDEX idx_tablename_columnname ON tablename (columnname);
Create a non clustered index
CREATE INDEX idx_tablename_columnname ON tablename (columnname);
Literals with Join
The VALUES constructor can be used to create a table of literals for use inside a query:
SELECT *
FROM (VALUES (@Id, @title), (1123, 'title')) AS literals (Id, Title)
LEFT JOIN Table_Name ON Table_Name.Id = literals.Id
Table Types
View user-defined table types
SELECT * FROM [sys].[objects]
WHERE [type] = 'TT'
ORDER BY create_date DESC