store procedure in sql server 2005

Posted by Sekar.c under Sql Server on 2/16/2012 | Points: 10 | Views : 1035 | Status : [Member] | Replies : 3
sir,
why using the @@ symbols in store procedure? And I need a example of this type?

Regards
Sekar.c



Responses

Posted by: Naraayanan on: 2/16/2012 [Member] Starter | Points: 25

Up
0
Down
Hi,
I think, @@ -- get Return Value .
http://msdn.microsoft.com/en-us/library/aa933158%28v=sql.80%29.aspx


Regards,
Lakshmi Naraayanan.S
http://dotnettechrocks.blogspot.in/
http://abaprocker.blogspot.com/

Sekar.c, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: Sriramnandha on: 6/26/2012 [Member] Starter | Points: 25

Up
0
Down

Hi Sekar,

@@ Symbol to return a Global Level Variable.

create Procedure sp_ProcedureTest
@@Testir int,
@testName varchar(90)
as
select * from Test where testid=@testid and Testname=@testname
Go

Hope this will help

Regards
Sriram.R





sriram

Sekar.c, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: Ajay.Kalol on: 6/26/2012 [Member] Starter | Points: 25

Up
0
Down
@@ Symbol is used to define global variables

Ajay
ajaypatelfromsanthal.blogspot.in

Sekar.c, if this helps please login to Mark As Answer. | Alert Moderator

Login to post response