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!
@pedrocorreia29113 жыл бұрын
My guy, I just want to thank you for the great work you're doing for free. I wish you well
@TECNOVIQ3 жыл бұрын
Thank you for your kind words.
@TECNOVIQ3 жыл бұрын
Watch the rest of the SQL Series videos here kzbin.info/aero/PLXfnbRd6NGx-57KX1YoYiWJ1x1gqxMlb3
@wednesdaysangel12 жыл бұрын
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.
@rafeekahamed75102 жыл бұрын
Very clear explanations , Thank you for your effort.
@saayoo34793 жыл бұрын
Thank you for this great video Sir!
@TECNOVIQ3 жыл бұрын
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
@raghavprasad2773 жыл бұрын
Thank you for this great video. Appreciate it.
@TECNOVIQ3 жыл бұрын
My pleasure!
@faiyazkhans56942 жыл бұрын
clear explanation..thanks
@TECNOVIQ2 жыл бұрын
Thank you 🙏
@janlauzy1404 Жыл бұрын
great explanation!
@TECNOVIQ Жыл бұрын
Thank you.
@akaganimemax32473 жыл бұрын
Thanks, great explanation ❤️❤️
@TECNOVIQ3 жыл бұрын
Thank you
@harshitshahi58562 жыл бұрын
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
@TECNOVIQ2 жыл бұрын
Hi, I am soon coming up with a full course. I shall share it with you soon.
@harshitshahi58562 жыл бұрын
@@TECNOVIQ Please ping as soon as it is out. Thanks
@jaganathjagu90102 жыл бұрын
Following
@diwaspoudel73 жыл бұрын
I think the function can be used for insert/update/delete in the case of PostgreSQL.
@TECNOVIQ3 жыл бұрын
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.
@TECNOVIQ3 жыл бұрын
I can do videos on PostgreSql if you need?
@diwaspoudel73 жыл бұрын
@@TECNOVIQ It's Ok. I understood the concept. This much is enough. :)
@frankokonkwo36624 жыл бұрын
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.
@TECNOVIQ4 жыл бұрын
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.
@frankokonkwo36624 жыл бұрын
@@TECNOVIQ THANK YOU, UNDERSTOOD
@dasarivenkatachalapathi63113 жыл бұрын
Hi SIR can you please explain when to use cursors, loops what is the difference between them,
@TECNOVIQ3 жыл бұрын
Sure. Thanks for your comment. I can make a video to explain about it 👍.
@antonyjayaraj953 жыл бұрын
Thanks for the content
@TECNOVIQ3 жыл бұрын
Thank you for your support 🙏
@suriyapriya45283 жыл бұрын
Keen explanation👏👏thank u😊
@TECNOVIQ3 жыл бұрын
Thank you 😊
@alexislychine91992 жыл бұрын
Thanks for this video 🙏🏻
@TECNOVIQ2 жыл бұрын
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-7862 жыл бұрын
great
@suryakanthbhullha74252 жыл бұрын
We can use delete and upadate in views,you can try it.
@TECNOVIQ2 жыл бұрын
You mean ON a view rather than IN?
@vibinjoseph91803 жыл бұрын
Why we can't run insert or update in a function ?
@TECNOVIQ3 жыл бұрын
It’s a limitation from the SQL server. Postgres uses functions for everything.