SQL SQL Server Specific
SQL Server-specific features — T-SQL, OUTPUT, TOP, PIVOT, STUFF, FOR XML. This category documents 44 SQL sql server specific entries, and each page gives you the full syntax, the parameter list, the return value, and a runnable example tested against MySQL, PostgreSQL, SQL Server, and SQLite. The entries are: OUTPUT Clause, STUFF(), FOR XML PATH, TRY...CATCH, @@IDENTITY / SCOPE_IDENTITY(), GETDATE() / SYSDATETIME(), STRING_SPLIT(), TOP ... WITH TIES, WAITFOR DELAY, FORMAT(), CHOOSE() / IIF(), TRY_CAST() / TRY_CONVERT(), EOMONTH(), NEWID() / NEWSEQUENTIALID(), COMPRESS() / DECOMPRESS(), DATEPART() / DATENAME(), PIVOT (SQL Server), OPENJSON(), HASHBYTES(), sys.tables / sys.columns, JSON_VALUE / JSON_QUERY, FOR JSON PATH / FOR JSON AUTO, SQL Server CTE Recursion Limit, SQL Server EXECUTE AS, SQL Server Error Handling (THROW), SQL Server Window Offset Functions, SQL Server Dynamic SQL (sp_executesql), SQL Server Common Table Expressions (Recursive), SQL Server PIVOT Dynamic Columns, SQL Server @@SPID, SQL Server DATABASE PROPERTYEX, SQL Server Error Functions, SQL Server STRING Functions, SQL Server RAISERROR, SQL Server APPLY with Table-Valued Function, SQL Server DYNAMIC DATA MASKING, SQL Server CHANGE TRACKING, SQL Server XML (FOR XML PATH), SQL Server BULK INSERT Options, SQL Server TEMPORAL TABLES, and more. Not sure where to start? OUTPUT Clause and STUFF() are the most commonly used entries in this category. You can also search across every category from the search page, browse the complete A–Z index, or try any of these statements live in the SQL playground.