1

I am reading stored procedures and reviewing them, I see this declartion in one of the procedures. It seems to me that it is trying to create a Temp Table named @uzovi_nummers. What I am trying to figure out is what is this "uzovi_nummer_n_4". Is it a custom datatype?

DECLARE @uzovi_nummers TABLE (
        uzovi_nummer uzovi_nummer_n_4,jaar INT
        )
Sid
  • 765
  • 5
  • 29
  • 57
  • It's the Column name & datatype I think. ( that's why i placed this in comment ) – Kallumasaurus Apr 28 '14 at 15:38
  • 2
    Yes, it's a user defined type. And to be precise, it's not a temp table, but table variable (very similar to temp table, but not exactly the same ) . – a1ex07 Apr 28 '14 at 15:40
  • Thanks, I just needed the confirmation. Would accept it as an answer. – Sid Apr 28 '14 at 15:41

1 Answers1

0

That is a table variable. A temp table would have a hash in front of it #temptable. Anything written in a query with a single @a in front will be a variable.

Also there are a fair amount of differences between a temp table and a table variable, this SO post would be good reading to understand the difference.

Community
  • 1
  • 1
rhealitycheck
  • 650
  • 3
  • 8
  • 19