SyntaxFix

[sql] Is there a way to get a list of all current temporary tables in SQL Server? 

SELECT left(NAME, charindex('_', NAME) - 1)
FROM tempdb..sysobjects
WHERE NAME LIKE '#%'
    AND NAME NOT LIKE '##%'
    AND upper(xtype) = 'U'
    AND NOT object_id('tempdb..' + NAME) IS NULL

you can remove the ## line if you want to include global temp tables.

Examples related to sql

• Passing multiple values for same variable in stored procedure • SQL permissions for roles • Generic XSLT Search and Replace template • Access And/Or exclusions • Pyspark: Filter dataframe based on multiple conditions • Subtracting 1 day from a timestamp date • PYODBC--Data source name not found and no default driver specified • select rows in sql with latest date for each ID repeated multiple times • ALTER TABLE DROP COLUMN failed because one or more objects access this column • Create Local SQL Server database

Examples related to sql-server

• Passing multiple values for same variable in stored procedure • SQL permissions for roles • Count the Number of Tables in a SQL Server Database • Visual Studio 2017 does not have Business Intelligence Integration Services/Projects • ALTER TABLE DROP COLUMN failed because one or more objects access this column • Create Local SQL Server database • How to create temp table using Create statement in SQL Server? • SQL Query Where Date = Today Minus 7 Days • How do I pass a list as a parameter in a stored procedure? • SQL Server date format yyyymmdd

Examples related to sql-server-2000

• SQL get the last date time record • INSERT INTO @TABLE EXEC @query with SQL Server 2000 • How to get the first and last date of the current year? • SQL select max(date) and corresponding value • SQL where datetime column equals today's date? • Is there a way to get a list of all current temporary tables in SQL Server? • Grant execute permission for a user on all stored procedures in database? • Is there a way to list open transactions on SQL Server 2000 database? • Get the time of a datetime using T-SQL? • select a value where it doesn't exist in another table

Examples related to temp-tables

• How to find difference between two columns data? • Temporary table in SQL server causing ' There is already an object named' error • SQL Server Creating a temp table for this query • Create a temporary table in MySQL with an index from a select • How can I simulate an array variable in MySQL? • When should I use a table variable vs temporary table in sql server? • Inserting data into a temporary table • TSQL select into Temp table from dynamic sql • dropping a global temporary table • Is there a way to get a list of all current temporary tables in SQL Server?