about the stored procedure

[Sonia Gupta]

i read somewhere two lines in the stored procedure. @companyname varchar(120), declare @companyname varchar(120), What is the differnce between them?

Sonia Gupta Soniagupta1@yahoo.co.in Yahoo messengerId-soniagupta1 Love is Friendship and Friendship is Love....

[Not Active]

In short, the first would be used to specify a parameter to the proc. The second would be to declare a variable to use with the proc

---

only two letters away from being an asset

[Piyush Vardhan Singh]

(@companyname varchar(120),) its declare to takes parameter for storprocr (declare @companyname varchar(120),) not take parameter

Piyush Vardhan Singh Programmer TAS NewDelhi India 9313077379

[sathesh pandian]

@companyname varchar(120) is the parameter which value will be sent by the user input. declare @companyname varchar(120) is the variable declared inside the procedure. if you are passing some arguments in the procedure, then you will never needed it to redeclare.

All The Best Sathesh Pandian

[Sonia Gupta]

thanks..:)

Sonia Gupta Soniagupta1@yahoo.co.in Yahoo messengerId-soniagupta1 Love is Friendship and Friendship is Love....

[Raghvendra Kumar Roy]

BY declare @companyname varchar(120) Variables are declared in the body of a batch or procedure with the DECLARE statement and are assigned values with either a SET or SELECT statement. While @companyname varchar(120) When we pass parameter in Procedure Then we stored them that parameter through Addparameter function.

Raghvendra Kumar Roy

[Piyush Vardhan Singh]

u have not given my answer yaar which i previews asked

Piyush Vardhan Singh Programmer TAS NewDelhi India 9313077379