Mam joins and subquery vaichi oru mini project mathiri concept eduthu work pani teach panuga mam.. apa tha joins yepa use panlam subquery yeppa use panlam yenga use panlam therium
Hi, superb content. Thanks for your efforts. Can you cover topics on creating functions, stored procedure inside function and transactions in sql(commit & rollback)
Thanks @gouthamvasudev4873. Refer to these videos for stored procedures, functions and transactions. th-cam.com/video/vJOsW41S16E/w-d-xo.html th-cam.com/video/uDuxANZCrog/w-d-xo.html th-cam.com/video/hnosXpd3-4U/w-d-xo.html
HI , In SQL enaku default constraint neengu panna mari pannaka "Column name or number of supplied values does not match table definition" nu kaatudhu,PLSSSSSSSSSSSSS help pannungu.plssssssssss reply soon madam🙏🙏🙏🙏🙏🙏🙏🙏🙏
Hi @SakthiBagav96-cd8ji, return in functions can be used to pass the value back to the caller which can be of any data type. There is no output parameter in functions. Whereas in stored procedures, there are both return and output parameter. Return in stored procedure can only return integer data type and it is mostly used as status codes like 0 for success and remaining numbers for failure. Whereas output parameters can be used to return the value back to the caller and there can be multiple output parameters with any datatype.
Very Very clear explanation. Heartly thanks for the wonder full session.
Mam joins and subquery vaichi oru mini project mathiri concept eduthu work pani teach panuga mam.. apa tha joins yepa use panlam subquery yeppa use panlam yenga use panlam therium
Mam daily basis la videos upload panuga mam yethana oru concept neegalea
Hi, superb content. Thanks for your efforts. Can you cover topics on creating functions, stored procedure inside function and transactions in sql(commit & rollback)
Thanks @gouthamvasudev4873. Refer to these videos for stored procedures, functions and transactions.
th-cam.com/video/vJOsW41S16E/w-d-xo.html
th-cam.com/video/uDuxANZCrog/w-d-xo.html
th-cam.com/video/hnosXpd3-4U/w-d-xo.html
HI , In SQL enaku default constraint neengu panna mari pannaka "Column name or number of supplied values does not match table definition" nu kaatudhu,PLSSSSSSSSSSSSS help pannungu.plssssssssss reply soon madam🙏🙏🙏🙏🙏🙏🙏🙏🙏
Hi @nandinipundipandu6163, Can you share your queries?
hi mam.. can you schedule full course of SQL SARVER
PIVOT, and UNPIVOT 22:41, 29:05, 39:02
Hi mam what is the difference between out parameter and return in sql konjam clear explain pls
Hi @SakthiBagav96-cd8ji, return in functions can be used to pass the value back to the caller which can be of any data type. There is no output parameter in functions. Whereas in stored procedures, there are both return and output parameter. Return in stored procedure can only return integer data type and it is mostly used as status codes like 0 for success and remaining numbers for failure. Whereas output parameters can be used to return the value back to the caller and there can be multiple output parameters with any datatype.