Contents tagged with temp
-
create a temp table in SQL Server that can hold the result of a stored procedure
https://dba.stackexchange.com/questions/12739/whats-the-easiest-way-to-create-a-temp-table-in-sql-server-that-can-hold-the-re
-
Power BI Calculated Tables and DAX Temp Tables
https://docs.microsoft.com/en-us/power-bi/desktop-calculated-tables
https://docs.microsoft.com/en-us/dax/calculatetable-function-dax
https://powerpivotpro.com/2017/02/uses-for-new-table-feature- … more
-
SQL Server Drop Temporary Table Syntax Enhancement in SQL Server 2016
SQL Server 2016 and onwards:
DROP TABLE IF EXISTS #MyTable
Prior to SQL Server 2016:
IF OBJECT_ID('tempdb.dbo.#MyTable', 'U') IS NOT NULL DROP TABLE #MyTable; more