sql local variable vs parameter. There are any references about sql local variable vs parameter in here. you can look below.