Type of Trigger in SQL Server
3:41
Пікірлер
@troops01
@troops01 12 күн бұрын
Very Nice. Thank you
@sandipmulmule
@sandipmulmule 17 күн бұрын
Sql server network configuration not found in SQL server configuration Manager , how to add it
@gkalyan-q1c
@gkalyan-q1c Ай бұрын
Hi sir Nice helping for me, I have query please help me , I am developing one web application it is in production, when I click submit button the application is crack, I don't have the source code, but I want to fix it , how can we troubleshoot it, front end Angular, backend .net core and db is MS SQL server
@sqliseasy
@sqliseasy Ай бұрын
Find Out where is the issue 1.front end is slow? --Verify how many records are processing and tune it if needed. 2.Db query sp is slow. --find out why the query is slow. ---- create nonclustered indexes on join condition columns if needed include select column also
@abcodyt
@abcodyt Ай бұрын
Thank you very much🎉
@tnadsofficialeditzs5648
@tnadsofficialeditzs5648 Ай бұрын
Nice explanation.But my question is..Create a procedure to fetch the details of students with the student ID being passed as an input parameter.
@tnadsofficialeditzs5648
@tnadsofficialeditzs5648 Ай бұрын
For exam
@sqliseasy
@sqliseasy Ай бұрын
Create procedure Usp_Studentdata (@StudentId int) As Begin Select * from where studentid =@StudentId End
@Evgeny-p8s
@Evgeny-p8s Ай бұрын
a very squeaky door
@sqliseasy
@sqliseasy 2 ай бұрын
Watch full video . kzbin.info/www/bejne/iXuol2yvjpxjpdksi=pMnjvGfPkCpbesR5
@aestheticcalisthenics2836
@aestheticcalisthenics2836 2 ай бұрын
are brother udar trust button show ho rha hai usse enable krna hai problem solve
@dusantost1425
@dusantost1425 2 ай бұрын
nice explanation, thank you 🙂
@Higheccentric
@Higheccentric 2 ай бұрын
Sir there is no option of pkhode
@sqliseasy
@sqliseasy 2 ай бұрын
Thats my server name Your server name could be your laptop name or Id .
@Shel-3ls
@Shel-3ls 2 ай бұрын
Great work!
@sqliseasy
@sqliseasy 2 ай бұрын
Thanks!
@imdanteasy
@imdanteasy 2 ай бұрын
Hello from 2024!😁Came here to say thank you! Your tutorial was really helpful!
@sqliseasy
@sqliseasy 2 ай бұрын
Thanks.
@NabothfmdNaasol-j9n
@NabothfmdNaasol-j9n 2 ай бұрын
My master lock me
@sqliseasy
@sqliseasy 2 ай бұрын
Sorry can you elaborate your question?
@CNetter
@CNetter 4 ай бұрын
it didnt work for me :/
@jakirhussain2412
@jakirhussain2412 4 ай бұрын
thank you for sharing knowledge
@Vivekpatvari765
@Vivekpatvari765 4 ай бұрын
Bro. , i am facing an issue in SQL , can u pls provide your contact numbrr or your insta id , so i can share you my problem and share screenshots
@timlawrence7204
@timlawrence7204 4 ай бұрын
Gonna be honest, I like how your video was unpolished and you identified and fixed errors in real time. I found this video very helpful!
@sqliseasy
@sqliseasy 4 ай бұрын
Glad you liked it!
@sqliseasy
@sqliseasy 4 ай бұрын
Also you can review my series on sql foundation:) kzbin.info/www/bejne/qHKWc6ScadeHac0
@arulvendhan9363
@arulvendhan9363 4 ай бұрын
If I insert the new rows in child table any errors are getting?
@sqliseasy
@sqliseasy 4 ай бұрын
@@arulvendhan9363 if reference value is present in Parent table then no error while insert.
@arulvendhan9363
@arulvendhan9363 4 ай бұрын
Table A deptid is null, table B deptid is null.. What is the output of innerjoin,left,right,fullouter
@sqliseasy
@sqliseasy 4 ай бұрын
Inner join - no data . Left join : all data from left table with null data from right table Right join : all data from the right table with null data from the left table. Full outer : all data from left table with null data from right table which will be union all with all data from right table with null data from left table.
@arulvendhan9363
@arulvendhan9363 4 ай бұрын
Thanks for brief explanation
@arulvendhan9363
@arulvendhan9363 4 ай бұрын
I have doubt for as alphanumeric characters [ABC0186] will be working or not for pattern?
@sqliseasy
@sqliseasy 4 ай бұрын
@@arulvendhan9363 it will work .
@arulvendhan9363
@arulvendhan9363 4 ай бұрын
😊
@arulvendhan9363
@arulvendhan9363 4 ай бұрын
If you are using large query shall we use it distinct keyword
@sqliseasy
@sqliseasy 4 ай бұрын
Yes.
@ashokbhumarapu1433
@ashokbhumarapu1433 4 ай бұрын
I need full videos
@sqliseasy
@sqliseasy 4 ай бұрын
@@ashokbhumarapu1433 " click on created By " title so you will be prompted to full video. Please let me know if you are still unable to link
@arulvendhan9363
@arulvendhan9363 4 ай бұрын
Good explanation
@sqliseasy
@sqliseasy 4 ай бұрын
Thank you .
@chinna_swamy
@chinna_swamy 4 ай бұрын
@arulvendhan9363
@arulvendhan9363 4 ай бұрын
Good explanation 🎉
@sqliseasy
@sqliseasy 4 ай бұрын
Glad you liked it
@arulvendhan9363
@arulvendhan9363 4 ай бұрын
Doubt for date and datetime column coming for data string format should I convert column or not?
@sqliseasy
@sqliseasy 4 ай бұрын
If the date is in the correct format then you don't need to convert .It will be converted automatically. If the date is not in the correct format then you need to first extract date in the correct format then cast it as a date .
@arulvendhan9363
@arulvendhan9363 5 ай бұрын
Assumes Joining Two tables if update some value Will be affected?
@sqliseasy
@sqliseasy 5 ай бұрын
Yes. Data will be affected based on join condition .
@arulvendhan9363
@arulvendhan9363 5 ай бұрын
@@sqliseasy thank you for your valueable reply
@muralisriram9001
@muralisriram9001 5 ай бұрын
Thanks for supporting SQL world.
@sqliseasy
@sqliseasy 5 ай бұрын
Any time!
@helloRChere
@helloRChere 5 ай бұрын
How many lectures are you planning to take ?
@sqliseasy
@sqliseasy 5 ай бұрын
As many as I can take :)
@sqliseasy
@sqliseasy 5 ай бұрын
Just honest feedback, is it worth uploading coming videos?
@ganeshreddy5590
@ganeshreddy5590 5 ай бұрын
Thank you brooo...finally i found the answer aftr 5 years❤
@ShrikantKhode
@ShrikantKhode 5 ай бұрын
Happy to hear
@ShrikantKhode
@ShrikantKhode 5 ай бұрын
You can also review new sql training and share with your network. Maybe it will be helpful. Sql Journey with Shrikant: kzbin.info/aero/PLGThsaJXH1wh36Px9G9wANnaZoPJbdJp9
@rkreddy428
@rkreddy428 5 ай бұрын
Thank you
@sqliseasy
@sqliseasy 5 ай бұрын
I would appreciate it if you can share it in your network.if you feel it will be useful for others
@sqliseasy
@sqliseasy 5 ай бұрын
Thanks for watching
@ShrikantKhode
@ShrikantKhode 5 ай бұрын
I would appreciate it if you can share it in your network.if you feel it will be useful for others
@ramkarthik7968
@ramkarthik7968 5 ай бұрын
Videos screen is not fully visible. Half Screen is visible
@sqliseasy
@sqliseasy 5 ай бұрын
Please click on created from sqliseasy or below link kzbin.info/www/bejne/f2aUdaSvd9Ssbqcsi=FYZ0S3RngSFAUhZX
@ramkarthik7968
@ramkarthik7968 5 ай бұрын
@@sqliseasy showing full screen in KZbin videos but in shorts it is not
@sqliseasy
@sqliseasy 5 ай бұрын
True.
@sqliseasy
@sqliseasy 5 ай бұрын
Yes.it has problem.
@sukkaka9920
@sukkaka9920 5 ай бұрын
sir as a non it employee in these which one is good to understand a non it candidate
@sqliseasy
@sqliseasy 5 ай бұрын
Can you please confirm your question?
@sukkaka9920
@sukkaka9920 5 ай бұрын
I am working in non it field but I want to change my filed into IT which one is good course to crack a job in IT
@sqliseasy
@sqliseasy 5 ай бұрын
You should learn the .net + sql server. Mostly people prefer Hyderabad to join classes. There you can join Naresh technology or Durga technology.
@jagadishm8264
@jagadishm8264 6 ай бұрын
thank u
@sqliseasy
@sqliseasy 6 ай бұрын
You're welcome!
@SujeethMaroli--BOSCH
@SujeethMaroli--BOSCH 6 ай бұрын
Rubbish....Bull Shit Info
@sqliseasy
@sqliseasy 6 ай бұрын
Sorry to hear this. Will work on improvement.
@Ganeshay-09
@Ganeshay-09 6 ай бұрын
dont repeating the same point ..once u explain take next point fastly..u are going to good explain in simply way nice keep it up bro
@sqliseasy
@sqliseasy 6 ай бұрын
Noted
@sqliseasy
@sqliseasy 6 ай бұрын
Sure.thanks for suggestion!
@ammarinho3035
@ammarinho3035 7 ай бұрын
thank you homie you a good guy
@venkataswamy.gswamy5389
@venkataswamy.gswamy5389 7 ай бұрын
Very good presentation, detailed explanation. It's informative session. Thank you and keep it up ❤🎉
@LifeMotivationRI
@LifeMotivationRI 7 ай бұрын
Thank you explaining SSAS in simple way.Can you do a series on all the MSBI tools explaned
@sqliseasy
@sqliseasy 7 ай бұрын
Sure thing!
@Riders59
@Riders59 7 ай бұрын
Thanks @Shrikant for an excellent vdo presented in a simple and sweet way to understand the complex topic of SSAS, MDX, Cubes et. al.💛
@ShrikantKhode
@ShrikantKhode 7 ай бұрын
Thank you sir!
@rashidmayana2644
@rashidmayana2644 7 ай бұрын
Wow
@ShrikantKhode
@ShrikantKhode 7 ай бұрын
@throughtheashes128
@throughtheashes128 7 ай бұрын
Thank u :)
@yashwanthv5604
@yashwanthv5604 7 ай бұрын
Thank you I've learnt good stuff from the playlist
@ghazeefafatima9546
@ghazeefafatima9546 8 ай бұрын
fixed my issue thanks
@sreeramchandu
@sreeramchandu 8 ай бұрын
Very nice