What is #, ##, @, @@ means in SQL?

  • @@ - System variables
  • @ - user defined variables
  • Local temporary table will be accessible to only current user session
  • Global temporary table will be accessible to all users