How to alter store procedure?

Question

Question

Vivek Nayak · Aug 22, 2019

I have created store procedure using management portal.

how to alter or modify SP using SQL in management portal.

Please refer below screen.

Discussion (3)0

Log in or sign up to continue

Eduard Lebedyuk · Aug 22, 2019

You can alter queries via Studio/Atelier/VS Code IDEs.

In portal you can run DROP QUERY and create the query again.

0 0

score 0 · Answer 1 · 2019-08-23T03:09:22-04:00

Vivek Nayak · Aug 23, 2019

Is it possible to alter SP using portal?

Something like below,

Alter query queryname()

0 0

score 0 · Answer 2 · 2019-08-23T03:25:01-04:00

Eduard Lebedyuk · Aug 23, 2019

Only DROP QUERY/CREATE QUERY.

0 0