There is a lot of talk about avoiding nvarchar in the database, in the examples did you create it with nvarchar for any specific reason or just because it is just an example?
Sir ..i really want to get to know that how i can become good at sql how i can do practice on it you have very good experience on it so plz tell me in beginning how you used to do practice on it ....
Hi Aman, honestly telling, I am whatever I know I learnt while working, and sometimes looking for a topic on google. For example If I want to learn user defined functions in sql, then I google User defined functions and I get many links where people have explained user defined functions with different examples, so if you practice at least 2-3 different examples then surely you will learn and understand it.
When you update Books, in the first set available books you are already subtracting 1 (one) book from the current transaction, in the next line why are you using available copies - 1 again? hasn't Available copies been updated already in the line before?
In the second column I am trying to update the Status column and for that I am using the case statement and checking if AvailableCopies-1 = 0. I think the whole row will be updated at the same time. So the value of availablecopies should change at the same time.
Hi akhil Ahmed please upload different stored procedure that would help us in realtime projects while working on sp to know each and everystatement and all give us more confidence to build the sp.
Sir, bina dekhe hi great. 😀. Waise mahnat bahut lagti he itni lambi video banane me. 28 min ki video he, unedited recorded video 45 min ki thi, to socho, recording, editing and then sub title writing bahut mahnat lagti he 😄
There is a lot of talk about avoiding nvarchar in the database, in the examples did you create it with nvarchar for any specific reason or just because it is just an example?
Sir ..i really want to get to know that how i can become good at sql how i can do practice on it you have very good experience on it so plz tell me in beginning how you used to do practice on it ....
Hi Aman, honestly telling, I am whatever I know I learnt while working, and sometimes looking for a topic on google. For example If I want to learn user defined functions in sql, then I google User defined functions and I get many links where people have explained user defined functions with different examples, so if you practice at least 2-3 different examples then surely you will learn and understand it.
@@learnssis thanks sir 😘
When you update Books, in the first set available books you are already subtracting 1 (one) book from the current transaction, in the next line why are you using available copies - 1 again? hasn't Available copies been updated already in the line before?
In the second column I am trying to update the Status column and for that I am using the case statement and checking if AvailableCopies-1 = 0.
I think the whole row will be updated at the same time. So the value of availablecopies should change at the same time.
Hi akhil Ahmed please upload different stored procedure that would help us in realtime projects while working on sp to know each and everystatement and all give us more confidence to build the sp.
okay sure.
HI Aquil if possible Please make a video on UDF's with real time scenario and using Proc inside a proc with an real time example
yeah sure, I will surely make videos on UDFs.
great sir...keep rocking
Thank you Kranthi.
Sir,kya aap ssis ki training de skte h mujhe Hindi me
Sorry me thoda busy chal raha hoon kuchh kaam ko lekar, to training dena mushkil hoga.
Ok koi ni sir,thank you so much for your valuable response
Really good!!
Thank you.
Great
Sir, bina dekhe hi great. 😀. Waise mahnat bahut lagti he itni lambi video banane me. 28 min ki video he, unedited recorded video 45 min ki thi, to socho, recording, editing and then sub title writing bahut mahnat lagti he 😄