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. ua-cam.com/video/vJOsW41S16E/v-deo.html ua-cam.com/video/uDuxANZCrog/v-deo.html ua-cam.com/video/hnosXpd3-4U/v-deo.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.
PIVOT, and UNPIVOT 22:41, 29:05, 39:02
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 mam.. can you schedule full course of SQL SARVER
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.
ua-cam.com/video/vJOsW41S16E/v-deo.html
ua-cam.com/video/uDuxANZCrog/v-deo.html
ua-cam.com/video/hnosXpd3-4U/v-deo.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 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.