@ notation in SQL Server

Question

I am new to SQL Server, can someone help me what is the significance of @ notation followed by name of variable? Like @OrderId ?

What has your researched turned up so far? – Newd Jul 21 '15 at 14:58 — Newd, Jul 21 '15 at 14:58

score 0 · Answer 1 · answered Jul 21 '15 at 15:29

All SQL Server variables are prefixed with @.

@local_variable
Is the name of a variable. Variable names must begin with an at (@) sign. Local variable names must comply with the rules for identifiers.

https://msdn.microsoft.com/en-us/library/ms188927.aspx

@ notation in SQL Server

1 Answers1