Difference between #temptable and ##TempTable?

by

#table refers to a local temporary table – visible to only the user who created it

##table refers to a global temporary table – visible to all users

More Related Contents:

  1. How to multiply column in Sql
  2. how to select next n letters after one specific letter using function in sql server by giving function name,specific letter, no of letters next
  3. SQL server query to output the data shown below
  4. Should you choose the MONEY or DECIMAL(x,y) datatypes in SQL Server?
  5. Will ANSI JOIN vs. non-ANSI JOIN queries perform differently?
  6. What is the difference between Integrated Security = True and Integrated Security = SSPI?
  7. How do you clear the SQL Server transaction log?
  8. How to use a variable for the database name in T-SQL?
  9. Order Of Execution of the SQL query
  10. What is the difference between char, nchar, varchar, and nvarchar in SQL Server?
  11. Missing artifact com.microsoft.sqlserver:sqljdbc4:jar:4.0
  12. Create a view with ORDER BY clause
  13. INSERT INTO vs SELECT INTO
  14. How to list all dates between two dates [duplicate]
  15. SQL Server sp_msforeachtable usage to select only those tables which meet some condition
  16. How to write UTF-8 characters using bulk insert in SQL Server?
  17. Number of times a particular character appears in a string
  18. SQL Server variable columns name?
  19. How to: Create trigger for auto update modified date with SQL Server 2008
  20. How can I Insert data into SQL Server using VBNet
  21. How do you set autocommit in an SQL Server session?
  22. Avg of float inconsistency
  23. Getting a warning when using a pyodbc Connection object with pandas
  24. Milliseconds wrong when converting from XML to SQL Server datetime
  25. How can I get the list of tables in the stored procedure?
  26. How to find the boundaries of groups of contiguous sequential numbers?
  27. SQL SERVER – Understanding how MIN(text) works
  28. Pivot multiple columns based on one column in SQL Server
  29. How to convert text column to datetime in SQL
  30. How to calculate difference in hours (decimal) between two dates in SQL Server?

Leave a Comment