What is the difference between query and stored procedure?

6

Reply

What is the difference between query and stored procedure?

Sekhar Konda

10y

249

0

Mukesh Kumar

Sp is precompiled query

8y

Mukesh Kumar

Sp is precompiled query

8y

Mukesh Kumar

Sp is precompiled query

8y

Mukesh Kumar

Sp is precompiled query

8y

Mukesh Kumar

We have to execute While procedure is compiled

8y

Sekhar Konda

Stored procedure will not compile again and again where simple Query compile every time then execute.From my side store procedure will be good.

10y