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

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

[@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]

Thanks

[@568_tycs_sahil_gupta7]

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]

So nice of you

[@MishaPrayuShow]

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

[@lotusamaze1142]

Happy to help

[@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

[@tastetemptations5193]

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

[@lotusamaze1142]

Glad you think so!

[@kinchalsharma3625]

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

[@lotusamaze1142]

You are most welcome

[@Ganesh-df7zn]

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

[@lotusamaze1142]

You are most welcome

[@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

[@sapnathakur4122]

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

[@lotusamaze1142]

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

[@sanjeebamat4485]

Easy to understand your lecture is so good thank you .

[@lotusamaze1142]

Thanks and welcome

[@ayazshaikh_t3997]

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

[@lotusamaze1142]

Happy to help you

[@mohitinfo2008]

brilliantly described, i hardly comment for channels!!

[@lotusamaze1142]

Glad you liked it!

[@komalyadav330]

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

[@lotusamaze1142]

You are most welcome

[@anasjawed5745]

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

[@lotusamaze1142]

Glad to hear that

[@zakiransari5714]

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

[@lotusamaze1142]

thanks

[@Vky915]

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

[@lotusamaze1142]

thx

[@ishaan-bhardwaj]

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

[@lotusamaze1142]

Glad you enjoyed it!

[@mukarramyaseen8570]

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

[@lotusamaze1142]

You are most welcome

[@satishb9975]

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

[@lotusamaze1142]

Glad you liked it

[@saudaminideshmukh2272]

Thanks for great explanation

[@lotusamaze1142]

You are welcome!

[@guduro7632]

Thanks a lot sir,way of explanation outstanding
Love from Rajasthan 💗💗

[@lotusamaze1142]

Most welcome For Training Call or WA 91-8076787743

[@nni_creation3480]

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

[@lotusamaze1142]

Glad you liked it!!

[@surender6980]

Thanks for explaining.

[@lotusamaze1142]

Glad it was helpful!

[@shrabonisinha]

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

[@lotusamaze1142]

All the best

[@worldaroundyou593]

Well explained thank you

[@lotusamaze1142]

Glad it was helpful!

[@viveckshukla]

बेहतरीन वीडियो गुरुजी !🙏

[@lotusamaze1142]

Thanks

[@Deepesh5122k]

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

[@lotusamaze1142]

Thanks

[@shubhamb9394]

Thanks dear great explained from scratch

[@lotusamaze1142]

Glad it was helpful!

[@avinashrochwani6404]

Thanks, great explanation.
Made it easy

[@tusharwagh9155]

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

[@lotusamaze1142]

Most welcome

[@ankitsaxena565]

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

[@lotusamaze1142]

Sure

[@shrikantaivale3630]

It's very useful videos . understand to easily

[@lotusamaze1142]

Thanks for liking

[@rohan_b_ra]

thanks a lots !!! Superb explanation

[@lotusamaze1142]

Thanks & Glad you liked it!

[@ambreeshkumaryadav9444]

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

[@lotusamaze1142]

Glad it was helpful!

[@syedshoeb149]

Great Video very informative and learning Thank You

[@lotusamaze1142]

Thanks

[@nakulbarot]

amazing ....now i understand this concept

[@lotusamaze1142]

Thanks

[@pranavkorhale5089]

nice explanation

[@lotusamaze1142]

Thanks for liking

[@AshishKumar00]

Thanks sir for this video, beautifully explained

[@lotusamaze1142]

Thanks

[@supritaberde91]

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]

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

[@supritaberde91]

@@lotusamaze1142 thnx sir for replying

[@supritaberde91]

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

[@lotusamaze1142]

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

[@harshadakatkar6868]

Thank you
You explained very well

[@lotusamaze1142]

So nice of you

[@dhaneshkumar3986]

It's very informative.
Thanks❤

[@lotusamaze1142]

Glad you liked it

[@wab8459]

Great Teaching sir. 👍👍👍

[@lotusamaze1142]

Thanks and welcome

[@bhaveshzala9006]

Thanks for video... its really helpful

[@lotusamaze1142]

Most welcome 😊

[@aradhanasingh6600]

Thank you for the Knowledge sir.!

[@lotusamaze1142]

My pleasure

[@indiawale7677]

wonderful explanation

[@lotusamaze1142]

Thanks

[@jagrutipatil1020]

Thank a lot sir🙏

[@lotusamaze1142]

Most welcome

[@deepakaggarwal8624]

AMAZING VIDEO SIR, thanks a lot for sharing

[@lotusamaze1142]

Most welcome

[@nileshdighe2048]

sir i want encryption for specific use then how to create

[@ArunKumar-jh4qe]

nice vedio with lot of info, thanks

[@lotusamaze1142]

Glad you liked it

[@swatiraykar2563]

Very helpful.. thank you sir

[@lotusamaze1142]

Happy to help

[@akhilkumar459]

thank you

[@lotusamaze1142]

Thanks

[@manojkule195]

good information learning skill is good sir

[@lotusamaze1142]

Keep watching

[@rakeshthakur9403]

Thank you so much for this video

[@lotusamaze1142]

Thanks

[@rajshreesonar956]

Sir your vdo is so help full. Can u make some vdo more

[@lotusamaze1142]

A playlist of sql server is already there in hindi & english

[@shankarjoshi9316]

Great video 👍

[@lotusamaze1142]

sure

[@ruchinpanchal29a62]

Best knowledge

[@lotusamaze1142]

Thanks

[@ashitoshthakur9402]

Dhanywad sir ji

[@lotusamaze1142]

Welcome

[@Entertainmenttv-fr5wx]

Sounds good for me

[@lotusamaze1142]

thx

[@no.more.official]

Thanks

[@lotusamaze1142]

Welcome

[@saurabhsingh88]

Very nice explanation. 👍

[@lotusamaze1142]

Glad you liked it

[@mdhasib4641]

Very Nice Explanation

[@lotusamaze1142]

Thanks and welcome

[@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

[@haseebraza1996]

amazing video

[@kumarsujal4969]

really amazing 👍👍👍
well explained

[@lotusamaze1142]

Glad you liked it

[@MishaPrayuShow]

I am your new subscriber..

[@lotusamaze1142]

Thanks and welcome

[@jawedakhtar3929]

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

[@lotusamaze1142]

sql function always return some value but stored procedure not

[@Tech-Nature-IND]

Great teaching

[@lotusamaze1142]

Glad it was helpful!

[@sameersuryawanshi145]

good explaination thankyou

[@lotusamaze1142]

You are welcome

[@vipindeoli3932]

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]

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'

[@shubhamranaware9203]

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

[@lotusamaze1142]

Definitely

[@lotusamaze1142]

I also take classes on SSAS, SSIS and SSRS

[@shubhamranaware9203]

@@lotusamaze1142 contact details.?

[@lotusamaze1142]

[e-mail]

[@learnjavascript2146]

Good content for beginners

[@lotusamaze1142]

Glad you think so!

[@snehalasunkute9162]

Very helpful 👍

[@lotusamaze1142]

Glad you think so!

[@vishalpawar-dm6fv]

thank you so much sir😊

[@lotusamaze1142]

Most welcome

[@divyashukla8163]

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]

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.

[@manishchandvlogs]

Can we say sp acts more like functions in programming?

[@abhayshekhawat3736]

Bhai zabbardast ❤

[@lotusamaze1142]

Thanks

[@RamRam-ce2yk]

Nice explanation ❤️

[@lotusamaze1142]

Glad you liked it

[@nasiaaslam217]

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

[@lotusamaze1142]

God bless you

[@ankitsaxena565]

Excellent sir

[@lotusamaze1142]

Many many thanks

[@ictglobal7175]

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.

[@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

[@sanjayjorawar8820]

nice

[@lotusamaze1142]

Thanks

[@E5330]

Amazing bro

[@lotusamaze1142]

Thank you so much 😀

[@E5330]

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

[@topcodeofficial]

excellent !!!!!!!

[@lotusamaze1142]

Glad you like it!

[@surajkushwaha4243]

Good Explain

[@lotusamaze1142]

Thanks for liking

[@SanjayKumar-yh8fd]

thanks sir, for the same

[@lotusamaze1142]

Always welcome

[@ravi__negi__4333]

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

[@lotusamaze1142]

Sure

[@nitishchoudhary201]

Best video❤

[@lotusamaze1142]

Thanks

[@vishalpoojary3686]

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

[@lotusamaze1142]

Sure I will

[@vishalpoojary3686]

@@lotusamaze1142 still waiting

[@Best_one007]

Great

[@lotusamaze1142]

Thanks

[@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

[@shikshaclasses5349]

Tq

[@lotusamaze1142]

Thanks

[@bvinod8338]

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

[@lotusamaze1142]

decryption is not provided in sql

[@theraushantiwari]

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

[@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

[@BijuVarghese]

How to decrypt stored procedure?

[@lotusamaze1142]

There is no way for decryption in sql

[@mohinibodake0217]

Anyone have written notes on this please let me know.

[@Aditya61515]

security kese pass kre stored procedure me

[@lotusamaze1142]

what security?

[@GauravSingh-di3dd]

this is not working in mySql

[@lotusamaze1142]

mysql is different from ms sql