what is the meaning of @ symbol in stored procedure

Posted by Gow.Net under Sql Server on 9/13/2012 | Points: 10 | Views : 4756 | Status : [Member] | Replies : 3
what is the meaning of @ symbol in stored procedure
for example
create proc (@param_name varchar(20))
here what is the meaning of "@ " Symbol

gowthaman8870226416


Responses

Posted by: Hariinakoti on: 9/13/2012 [Member] Starter | Points: 25

Up
0
Down
@ it is indicating parameter

Thanks & Regards
Hari

Gow.Net, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: Vivekjj on: 11/6/2012 [Member] Starter | Points: 25

Up
0
Down
its a variable or parameters

Gow.Net, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: Sourabh07 on: 11/7/2012 [Member] Starter | Points: 25

Up
0
Down
hi..

When we are declaring a local variable in the Sql Server, it is mandatory that we have to define it with the prefix @

eg:

Declare @id int


It is same in parameter section too......

Sourabh07

Gow.Net, if this helps please login to Mark As Answer. | Alert Moderator

Login to post response