Results 1 to 9 of 9
Thread: which variable to use ?
Oct 11, 2012, 01:15 #1
- Join Date
- Dec 2009
- 0 Post(s)
- 0 Thread(s)
which variable to use ?
I have a confusion regarding defining variables in stored procedure . We can define variable in store procedure in two different ways .....
I am confused because ...
(a)why there are two ways to define a variable ?
(b)I'm not clear when to use DECLARE and when to use SET . Can you please explain the difference ? Is there any thumb rule when to use which variable ?