Choosing Between Views, Functions, and Stored Procedures in SQL With Examples

[@TECNOVIQ]

If you enjoyed this video and would like to see more, please consider subscribing to our channel. I appreciate your support and it helps me create more content. Currently, only a small percentage of viewers are subscribed, so I would be grateful if you could help me grow our community. Thank you for watching!

[@pedrocorreia2911]

My guy, I just want to thank you for the great work you're doing for free. I wish you well

[@TECNOVIQ]

Thank you for your kind words.

[@TECNOVIQ]

Watch the rest of the SQL Series videos here kzbin.info/aero/PLXfnbRd6NGx-57KX1YoYiWJ1x1gqxMlb3

[@wednesdaysangel1]

that was great, and I think this channel seems underrated. My class teacher does not ask that we actually create our own functions and stored procedures but rather has us copying and pasting them from the assignment outline to Microsoft SQL Server, but I think that would be interesting to go through a sort of live tutorial where the host instructs how to go about building and the syntax of the functions and stored procedures.

[@TECNOVIQ]

Thanks for your comment. Please help the channel by subscribing. I have been inactive for a while and I will be posting new videos soon. If you have any topics you want me to go through let me know.

[@rafeekahamed7510]

Very clear explanations , Thank you for your effort.

[@saayoo3479]

Thank you for this great video Sir!

[@TECNOVIQ]

Thank you for your kind comment.

[@mohitjain1234512]

Very nice explanation. Thank you

[@TECNOVIQ]

Thank you 🙏

[@TECNOVIQ]

Please share with your friends and colleagues to watch and subscribe

[@raghavprasad277]

Thank you for this great video. Appreciate it.

[@TECNOVIQ]

My pleasure!

[@faiyazkhans5694]

clear explanation..thanks

[@TECNOVIQ]

Thank you 🙏

[@janlauzy1404]

great explanation!

[@TECNOVIQ]

Thank you.

[@akaganimemax3247]

Thanks, great explanation ❤️❤️

[@TECNOVIQ]

Thank you

[@harshitshahi5856]

Can you pls show how to debug a big SP and create dynamic queries etc. Also make a course on Azure Data engineering (including ADF, Az databricks) etc ! Paid is fine if you can give proper guidance & support

[@TECNOVIQ]

Hi, I am soon coming up with a full course. I shall share it with you soon.

[@harshitshahi5856]

@@TECNOVIQ Please ping as soon as it is out. Thanks

[@jaganathjagu9010]

Following

[@diwaspoudel7]

I think the function can be used for insert/update/delete in the case of PostgreSQL.

[@TECNOVIQ]

Hi thanks for the message. You are right. These SQL videos are for SQL Server though which I mentioned in the first video in the series.

[@TECNOVIQ]

I can do videos on PostgreSql if you need?

[@diwaspoudel7]

@@TECNOVIQ It's Ok. I understood the concept. This much is enough. :)

[@frankokonkwo3662]

Thank you for the video but why do you always start with drop function/procedure if exists? Confused why we are dropping when we are trying to create.

[@TECNOVIQ]

Thanks for your comment. The reason I drop function or procedure is that, it makes the script reusable. You can use ‘ALTER’ after creating them but only if they were already created.

[@frankokonkwo3662]

@@TECNOVIQ THANK YOU, UNDERSTOOD

[@dasarivenkatachalapathi6311]

Hi SIR can you please explain when to use cursors, loops what is the difference between them,

[@TECNOVIQ]

Sure. Thanks for your comment. I can make a video to explain about it 👍.

[@antonyjayaraj95]

Thanks for the content

[@TECNOVIQ]

Thank you for your support 🙏

[@suriyapriya4528]

Keen explanation👏👏thank u😊

[@TECNOVIQ]

Thank you 😊

[@alexislychine9199]

Thanks for this video 🙏🏻

[@TECNOVIQ]

Thanks for the support. Please share with others!

[@frikosimon]

Thank you, now i am ready to do my exam haha

[@TECNOVIQ]

Glad to hear that. Let me know if you need further help in future.

[@ZiaulHaqOfficial-786]

great

[@suryakanthbhullha7425]

We can use delete and upadate in views,you can try it.

[@TECNOVIQ]

You mean ON a view rather than IN?

[@vibinjoseph9180]

Why we can't run insert or update in a function ?

[@TECNOVIQ]

It’s a limitation from the SQL server. Postgres uses functions for everything.

[@narayanjena4259]

Very good explanation. Thank You

[@TECNOVIQ]

Thanks for your support 👍