Creating And Using Functions in MS SQL - With Examples!!

[@vijay6face]

Useful one thanks

[@ShahbaazKhan]

Glad the content was helpful!

[@jonathanjordan21]

sir, does this only works for Microsoft DBMS? bcs i cannot use it on MYSQL Benchmark

[@ShahbaazKhan]

The idea is same, but the concept should be same. Please refer to this link to work with MySQL specifically www.mysqltutorial.org/mysql-stored-function/

[@jonathanjordan21]

@@ShahbaazKhan Oh, i see. thats why my code doesnt work

[@jonathanjordan21]

@@ShahbaazKhan Sir, does MySql Server support function to return table? i spent hours to do the trick but it didnt work.

[@ShahbaazKhan]

@@jonathanjordan21 No, as per documentation it only allows {STRING|INTEGER|REAL|DECIMAL} . However, you can utilize a stored procedure to achieve the same result. Please refer to this link -> stackoverflow.com/questions/23421771/how-to-return-table-from-mysql-function

[@Prince-eo8cn]

Super well said 👍👍

[@ShahbaazKhan]

Glad that was helpful : D

[@mttwss]

Your private message feature is not set up in the 'about' area of your channel.

[@ShahbaazKhan]

Hi, I think the feature was removed in 2019. You can still use my email to reach out with any question you have. As, this channel is small, I do not have any social media set up yet.

[@daalwada]

Hi, you told that the values 'a,b,c,d',',' will be separated by commas, but in the result it does not show comma. I think you mean, wherever the comma appears, it splits the character and then shows as a separate row value, isn't it?

[@ShahbaazKhan]

Yes. Correct.

[@Afalaa]

Great video, but your camera is bit far away from ssms.

[@TheSQLGuy]

Really nice tutorial

[@ShahbaazKhan]

Glad you it helped you :)

[@7to7media]

why do we use stored functions in sql

[@ShahbaazKhan]

Because sometimes we might need a custom functionality, that is not provided by the SQL, multiple times. This concept is very similar to functions in other programming languages.

[@daalwada]

Stored Procedures(SP) actually help programmers to use the same methods multiple times. If you don't use SP, you have re-write those methods again and again every time you perform CRUD operation. So SP helps to create a method and store it in one place so that we can use anytime anywhere.

[@SteveoStories]

I appreciate the effort but you make a ton of mistakes that can be just edited out.. thanks for the vid

[@ShahbaazKhan]

Feedback received, continuously working to improve content quality in each video.

[@Prince-eo8cn]

Please upload more videos SQL server

[@ShahbaazKhan]

Any suggestions ?

[@AshriLucky]

Getting erroe as Invalid Object String_Split

[@ShahbaazKhan]

Make sure you are using MS SQL and have appropriate configurations. You can check out this answer and see if it helps. stackoverflow.com/questions/47205829/sql-server-2016-invalid-object-name-string-split

[@GooseGumlizzard]

my created function is nowhere to be found in the functions folder, why?

[@daalwada]

You might not have refreshed it. Refresh the 'Functions' folder and then check.

[@anitapanigrahi9461]

We cannot use the scalar function in update statement? I need something on that.

[@ShahbaazKhan]

I think we can use scalar function in update statement, below is a snippet which I tried after your question. UPDATE [dbo].[Test_Update] SET [id] = dbo.AddTwoNumbers(2,6) WHERE string = 'adsf' Here Test_Update is a table I create and added a row, later I updated the Id(which is not a key) using a scalar valued function which is very similar to the one created in this video

[@piyushipawan7254]

delimiter*

[@unknownad_official]

can we call a function without ceating it?

[@ShahbaazKhan]

Yes, If you have an existing function you can call it. There are a few functions that are provided by MSSQL which you can use. But if you have a custom requirement you need to create your own method, once create you can use it as many time as you want in that database. Hope this answers the question.

[@unknownad_official]

@@ShahbaazKhan to be honest... im working on a web shell project and i need to execute a Python code with in the databases that supports plpython3u extention such as postgres

[@ShahbaazKhan]

@@unknownad_official Yes, you can create and use the extension and use python language to create funcitons. Here is the link for offcial pl/python for pgsql www.postgresql.org/docs/9.1/plpython-funcs.html

[@pleabargain]

What application are you using? Which v. of SQL?

[@ShahbaazKhan]

SQL Server 2016

[@sergiovasquezvasquez5326]

GOD

[@sakijilan7908]

sorry you really have to get the kinks out of your programming skills, before making another video.

[@ShahbaazKhan]

Sure, thank you for the feedback : )