What is the difference between query and stored procedure?
Sekhar Konda
Sp is precompiled query
We have to execute While procedure is compiled
Stored procedure will not compile again and again where simple Query compile every time then execute.From my side store procedure will be good.