Temp variable can be created like this:

Table variable is always useful for less data. If the result set returns a large number of records, we need to go for temp table.

Leave a Reply

Your email address will not be published. Required fields are marked *