SQL Stored procedure Hindi | Stored Procedure in SQL Server for Beginners

Подписаться 25 тыс.

Просмотров 234 тыс.

50% 1

SQL Stored procedure Hindi | How to Write Stored Procedure in SQL Server for Beginners.
SQL stored procedure in hindi will help you to understand how to create stored procedure, how to alter stored procedure, how to apply parameters in stored procedure.
MS SQL Hindi Playlist : • SQL Tutorials-Hindi
MS SQL English Playlist : • SQL Tutorial-English
Power BI DAX Hindi Playlist : • DAX Hindi
Power BI DAX English Playlist : • DAX English
Power BI Hindi Playlist : • Power BI Tutorials-Hindi
Power BI English Playlist : • Power BI Tutorials-Eng...
#sqlserver #sql #sqlinterviewquestions #mssqlserver #sqlforbeginners #education #rdbms #sqlcourse #sqlcommands

Опубликовано:

27 сен 2024

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист

Посмотреть позже

Комментарии : 247

@ketanarora278 Год назад

A really great Demonstration video i have ever seen so far. You are a really great guru sir. Thank you so much for making such a great content with in depth explanation.

@lotusamaze1142 Год назад

Thanks

@568_tycs_sahil_gupta7 2 года назад

Bro really tnx for this explaination. Hats off to you bro. Thank you from bottom of my heart. Your YT channel needs more attention. You are hardworking bro. Keep drilling❤️❤️

@lotusamaze1142 2 года назад

So nice of you

@MishaPrayuShow 3 года назад

Very perfect explanation... First time I know what is stored procedure.. Thanks you so much..

@lotusamaze1142 3 года назад

Happy to help

@nasiaaslam217 Месяц назад

Thank you so much. your way of teaching is very easy understandable and this tutorial is helpful to clear the concept of SP.

@lotusamaze1142 20 дней назад

Thanks

@pramod1234ist Год назад

Happy to learn from you ...very easy to understand. I now understand what the stored procedure ... U solve all questions which are in my mind....thanks a lot sir. 👍

@lotusamaze1142 Год назад

Glad to hear that

@tastetemptations5193 3 месяца назад

Best video over Store procedure on youtube, the way u explained

@lotusamaze1142 3 месяца назад

Glad you think so!

@sapnathakur4122 7 месяцев назад

In depth explanation like no other channel. Great work sir. 🙏

@lotusamaze1142 7 месяцев назад

Thanks a ton

@sonammishra2964 Год назад

I paid 18k for sql still had doubt on procedure function etc but this vidoes cleared my all doubt Thank you so much 💓 💗 💛

@lotusamaze1142 Год назад

God bless you

@ayazshaikh_t3997 2 года назад

after spending 2 days final understood this concept from you... thank you

@lotusamaze1142 2 года назад

Happy to help you

@kinchalsharma3625 Год назад

Thanks you....Now store procedure become simple and easy for me. very well explained

@lotusamaze1142 Год назад

You are most welcome

@mohitinfo2008 Год назад

brilliantly described, i hardly comment for channels!!

@lotusamaze1142 Год назад

Glad you liked it!

@anasjawed5745 Год назад

Very Supportive Content, its really helped the way you delivered, now its make very simple 💯Thank you SIR

@lotusamaze1142 Год назад

Glad to hear that

@komalyadav330 9 месяцев назад

Thank you sir... The way you explain this concept is very simple and understanding..

@lotusamaze1142 9 месяцев назад

You are most welcome

@zakiransari5714 6 месяцев назад

Very informative.... apka seekhanay ka method bht acha ha , bht maza aaya! thanks. I found you ever on youtube.

@lotusamaze1142 6 месяцев назад

thanks

@satishb9975 2 года назад

Thank you very well explained, 👍 with clarity, learners need these kind of explanation for preparation

@lotusamaze1142 2 года назад

Glad you liked it

@ishaan-bhardwaj Год назад

great tutorial, to the point and very clear explanation. thank you!

@lotusamaze1142 Год назад

Glad you enjoyed it!

@nni_creation3480 Год назад

You explained everything in detail. Thank you so much!!

@lotusamaze1142 Год назад

Glad you liked it!!

@supritaberde91 2 года назад

Hello, Ur video was very informative. Thnx for explaining nicely. I have one query that as u explained in video a out how to encrypt the stored procedure, kindly explain about how to decrypt the same through commands and UI. Expect ur reply at the earliest

@lotusamaze1142 2 года назад

It is not so simple, you can check this link : www.sqlservercentral.com/blogs/simple-way-to-decrypt-sql-server-stored-procedure

@supritaberde91 2 года назад

@@lotusamaze1142 thnx sir for replying

@supritaberde91 2 года назад

@@lotusamaze1142 Sir There your on Power BI. If yes pls upload.

@lotusamaze1142 2 года назад

Power BI and DAX Function playlist are already on channel in English & Hindi

@shrabonisinha 2 года назад

Thank You so much. Mera concept fully clear ho gaya hai

@lotusamaze1142 2 года назад

All the best

@nileshdighe2048 16 дней назад

sir i want encryption for specific use then how to create

@Deepesh5122k Год назад

Thank you so much mate for such a simplified explanation ❤ Big thanks

@lotusamaze1142 Год назад

Thanks

@ankitsaxena565 3 года назад

Sir aap video bnate rhiye aise hi bhut aage jayega aapka channel

@lotusamaze1142 3 года назад

Sure

@surender6980 2 года назад

Thanks for explaining.

@lotusamaze1142 2 года назад

Glad it was helpful!

@jawedakhtar3929 2 года назад

It is looking same as user define function , then what is difference between stored procedure and user define function?

@lotusamaze1142 2 года назад

sql function always return some value but stored procedure not

@shubhamranaware9203 3 года назад

sir kya aap SSRS(Sql Server Reporting Services) tutorials lenge kya

@lotusamaze1142 3 года назад

Definitely

@lotusamaze1142 3 года назад

I also take classes on SSAS, SSIS and SSRS

@shubhamranaware9203 3 года назад

@@lotusamaze1142 contact details.?

@lotusamaze1142 3 года назад

lotusamaze@gmail.com

@harshadakatkar6868 Год назад

Pls make a video on conditions and for validation in stored procedures i.e if else if else and all other conditions. also how we can pass multiple values to a single input parameter using array. some advance concepts in SP

@lotusamaze1142 Год назад

Sure

@tusharwagh9155 2 года назад

Very simple & good explain, Thanks Sir ....

@lotusamaze1142 2 года назад

Most welcome

@shrikantaivale3630 3 года назад

It's very useful videos . understand to easily

@lotusamaze1142 3 года назад

Thanks for liking

@ambreeshkumaryadav9444 2 года назад

Really explained very well. Thank u so much❤️❤️❤️❤️

@lotusamaze1142 2 года назад

Glad it was helpful!

@rohan_b_ra 2 года назад

thanks a lots !!! Superb explanation

@lotusamaze1142 2 года назад

Thanks & Glad you liked it!

@syedshoeb149 Год назад

Great Video very informative and learning Thank You

@lotusamaze1142 Год назад

Thanks

@manishchandvlogs 11 месяцев назад

Can we say sp acts more like functions in programming?

@pranavkorhale5089 2 года назад

nice explanation

@lotusamaze1142 2 года назад

Thanks for liking

@nakulbarot Год назад

amazing ....now i understand this concept

@lotusamaze1142 Год назад

Thanks

@ictglobal7175 8 месяцев назад

HI, Thanks for your video. I have questions about it. I'm using two database example: DB1 & DB 2, DB1 are many time drop and add another DB2 are still in my sql server. I want to using store procedure in DB2 which is use in DB1 database. have any suggestions??? help me.

@vipindeoli3932 2 года назад

Very informative !! Can you please explain if I have to pass two argument in department Ex: depart_ID 1 & 2 and Emp_Name. how can we do ?

@lotusamaze1142 2 года назад

CREATE Procedure ParamProc @Emp_Name Varchar(100), @Depart_ID INT AS BEGIN Print 'Emp Name:'+@Emp_Name ; Print 'Depart ID:'+@Depart_ID ; END ------------------ exec ParamProc @Depart_ID=3,@Emp_Name='Smith'

@harshadakatkar6868 Год назад

Thank you You explained very well

@lotusamaze1142 Год назад

So nice of you

@aradhanasingh6600 Год назад

Thank you for the Knowledge sir.!

@lotusamaze1142 Год назад

My pleasure

@nileshdighe2048 Год назад

Sir i have a question ki hum stored procedure banate hain thike ki time bachta hain but mera questions ye hain ki vo to hum directly bhi query write kar sakate hain n choti query ho to muje pata karna hain ki other than reuse hum kiske liye use karte hain plzz guide

@lotusamaze1142 Год назад

for complex query write sp otherwise you can use query

@dhaneshkumar3986 Год назад

It's very informative. Thanks❤

@lotusamaze1142 Год назад

Glad you liked it

@saritatanwar8228 Год назад

Thanks you so much for explaining so nicely. kya aap java sikha sakte ho please. agar aapka koe batch chal rha hai to mein join kr sakti hu. aur agar aap Java hindi video upload kr sakte ho to, please btayega🙏

@lotusamaze1142 Год назад

Java Video are in pipeline

@wab8459 3 года назад

Great Teaching sir. 👍👍👍

@lotusamaze1142 3 года назад

Thanks and welcome

@indiawale7677 Год назад

wonderful explanation

@lotusamaze1142 Год назад

Thanks

@deepakaggarwal8624 Год назад

AMAZING VIDEO SIR, thanks a lot for sharing

@lotusamaze1142 Год назад

Most welcome

@manojkule195 6 месяцев назад

good information learning skill is good sir

@lotusamaze1142 5 месяцев назад

Keep watching

@Entertainmenttv-fr5wx 5 месяцев назад

Sounds good for me

@lotusamaze1142 5 месяцев назад

thx

@haseebraza1996 8 месяцев назад

amazing video

@shankarjoshi9316 7 месяцев назад

Great video 👍

@lotusamaze1142 7 месяцев назад

sure

@swatiraykar2563 Год назад

Very helpful.. thank you sir

@lotusamaze1142 Год назад

Happy to help

@rakeshthakur9403 Год назад

Thank you so much for this video

@lotusamaze1142 Год назад

Thanks

@MishaPrayuShow 3 года назад

I am your new subscriber..

@lotusamaze1142 3 года назад

Thanks and welcome

@no.more.official Месяц назад

Thanks

@lotusamaze1142 Месяц назад

Welcome

@saurabhsingh88 2 года назад

Very nice explanation. 👍

@lotusamaze1142 2 года назад

Glad you liked it

@ruchinpanchal29a62 2 года назад

Best knowledge

@lotusamaze1142 2 года назад

Thanks

@mdhasib4641 2 года назад

Very Nice Explanation

@lotusamaze1142 2 года назад

Thanks and welcome

@laiqmehdi8704 Год назад

Thnx alot god bless you

@lotusamaze1142 Год назад

So nice of you

@ashitoshthakur9402 3 года назад

Dhanywad sir ji

@lotusamaze1142 3 года назад

Welcome

@realknowledge-23 2 месяца назад

thank you sir this tutorial help us became 0 to hero.

@lotusamaze1142 2 месяца назад

Glad to hear that

@kumarsujal4969 Год назад

really amazing 👍👍👍 well explained

@lotusamaze1142 Год назад

Glad you liked it

@sameersuryawanshi145 2 года назад

good explaination thankyou

@lotusamaze1142 2 года назад

You are welcome

@vishalpoojary3686 5 месяцев назад

hi sir please provide tables which you have saved in SQL to practice

@lotusamaze1142 5 месяцев назад

Sure I will

@vishalpoojary3686 4 дня назад

@@lotusamaze1142 still waiting

@vishalpawar-dm6fv Год назад

thank you so much sir😊

@lotusamaze1142 Год назад

Most welcome

@snehalasunkute9162 Год назад

Very helpful 👍

@lotusamaze1142 Год назад

Glad you think so!

@bvinod8338 Год назад

After applying with encryption how will the administrator able to see the sp_helptext

@lotusamaze1142 Год назад

decryption is not provided in sql

@RamRam-ce2yk 3 года назад

Nice explanation ❤️

@lotusamaze1142 3 года назад

Glad you liked it

@learnjavascript2146 Год назад

Good content for beginners

@lotusamaze1142 Год назад

Glad you think so!

@ravi__negi__4333 Год назад

bring some more reak scenrio videos ...trhanks a lot i subceibre

@lotusamaze1142 Год назад

Sure

@sanjayjorawar8820 Год назад

nice

@lotusamaze1142 Год назад

Thanks

@surajkushwaha4243 5 месяцев назад

Good Explain

@lotusamaze1142 5 месяцев назад

Thanks for liking

@Pranjul-yw8ig Год назад

How a stored procedure is difierent from trigger..?

@lotusamaze1142 Год назад

SP is called explicitly and trigger execution is dependent on event like insert, update, delete

@SanjayKumar-yh8fd 2 года назад

thanks sir, for the same

@lotusamaze1142 2 года назад

Always welcome

@nitishchoudhary201 Год назад

Best video❤

@lotusamaze1142 Год назад

Thanks

@mohinibodake0217 3 месяца назад

Anyone have written notes on this please let me know.

@Best_one007 Год назад

Great

@lotusamaze1142 Год назад

Thanks

@shikshaclasses5349 Год назад

@lotusamaze1142 Год назад

Thanks

@Aditya61515 6 месяцев назад

security kese pass kre stored procedure me

@lotusamaze1142 6 месяцев назад

what security?

@GauravSingh-di3dd Год назад

this is not working in mySql

@lotusamaze1142 Год назад

mysql is different from ms sql

@weddfilmerkitty4983 2 года назад

hllo sir

@weddfilmerkitty4983 2 года назад

mer kuch doubut h

@weddfilmerkitty4983 2 года назад

kya CASE condition di h us pe perameter use karna h

@lotusamaze1142 2 года назад

yes

@Ganesh-df7zn 2 года назад

Very nice explanation and also very knowledgeable video about stored procedure ....thank you

@lotusamaze1142 2 года назад

You are most welcome

@deepakgupta6764 3 года назад

Very nicely explained

@lotusamaze1142 3 года назад

Thanks for liking

@Digital_Vishnoo Год назад

very well explained

@lotusamaze1142 Год назад

Thanks for liking

@aparnakavinkar7991 2 года назад

Nice explaination

@lotusamaze1142 2 года назад

Thanks for liking

@nasiaaslam217 Месяц назад

Thank you so much. Great Job. Really,your teaching way is very easy and understandable.

@lotusamaze1142 20 дней назад

God bless you

@sanjeebamat4485 2 года назад

Easy to understand your lecture is so good thank you .

@lotusamaze1142 2 года назад

Thanks and welcome

@satishchaurasia84ya 2 года назад

Great job. Thanks🙏 alot all in one video.

@lotusamaze1142 2 года назад

Glad you liked it!

@saudaminideshmukh2272 2 года назад

Thanks for great explanation

@lotusamaze1142 2 года назад

You are welcome!

@worldaroundyou593 2 года назад

Well explained thank you

@lotusamaze1142 2 года назад

Glad it was helpful!

@rashmiranjankhuntia7147 4 месяца назад

I am not able to understand since a long back after watching your way of expressing easily catch up, Thank you Sir

@lotusamaze1142 4 месяца назад

Glad to hear that

@yatinbagul3932 3 года назад

Maja aah gaya sir just keep posting we need and in Hindi very rare videos are their

@lotusamaze1142 3 года назад

Thanks

@Vky915 9 месяцев назад

"I appreciate your explanation. Thank you very much."

@lotusamaze1142 9 месяцев назад

thx

@ShivShankarSharma81017 2 года назад

Thanks for making this. Awesome explanation.

@lotusamaze1142 2 года назад

Glad it was helpful!

@akhilkumar459 2 месяца назад

thank you

@lotusamaze1142 2 месяца назад

Thanks

@jagrutipatil1020 11 месяцев назад

Thank a lot sir🙏

@lotusamaze1142 11 месяцев назад

Most welcome

@theraushantiwari 5 месяцев назад

Sir, i need this notes. please provide me!!

@avinashrochwani6404 Год назад

Thanks, great explanation. Made it easy

@abhikatiyar5103 Год назад

Thanks

@lotusamaze1142 Год назад

Welcome

@mukarramyaseen8570 6 месяцев назад

Thanks a lot for this detailed video, your way of teaching is also easy to understand for beginners like Me.

@lotusamaze1142 5 месяцев назад

You are most welcome

@shalinigarg859 3 года назад

Thank you so much, Sir. Great efforts 👍 Please expand your channel with Python also.

@lotusamaze1142 3 года назад

Sure

@E5330 10 месяцев назад

Amazing bro

@lotusamaze1142 10 месяцев назад

Thank you so much 😀

@E5330 10 месяцев назад

@@lotusamaze1142 keep uploading more videos for students' enlightenment 🙏Jai Hind

@divyashukla8163 2 года назад

Good info. Could you please tell me how we can pass the date variable. Means I want to set dynamic date in a query

@lotusamaze1142 2 года назад

always pass date format in global format i.e yyyy-mm-dd '2022-11-10'. Sql server will automatically convert this format in date format. Declare the parameter in stored procedure datetime type.