Answers for "temp table vs variable table in sql server"

SQL

1

temp table vs variable table in sql server

DECLARE @TableExample TABLE(some columns); --Table variable.

CREATE TABLE #TempTable(Ssome columns); --Temporal table.

Temp tables are a good choice if you're handling large data but if it's a small
data that you'll be handling, table variable are a great choice since they operate
on the ram(memory).

Posted by: Guest on January-06-2022

Code answers related to "temp table vs variable table in sql server"

Code answers related to "SQL"

Browse Popular Code Answers by Language

Python

Javascript

Whatever

Shell/Bash

CSS

Html

PHP

SQL

Java

C#