michael, I hope you have an opportunity to read this in the near future. I am currently enrolled in an sql database class at a local community college and your videos have been a life saver for me. please dont stop making these videos if you can help it as im sure they will benefit me and alot of others in the future. thank you so much for your videos and your time.
Thank you so much, Michael! I have experience with writing SQL queries and have been trying to further my knowledge by learning T-SQL and also learn how to create and edit stored procedures. I am hoping to use this new knowledge for a new job opportunity I am applying for, so again, thank you for your wonderful explanation and examples! I followed everything you said beautifully :)
I enjoyed watching this video. Thanks for educating the community and appreciate your volunteer-ship. Keep producing some more videos. Especially make a mistake and correct the error and explain how it has ben fixed will attract audience. Especially create some videos with tips and tricks may click your video hits more. Thanks a lot
How can I populate a column in (tempd table). the column having Null values returned from a left join query of 2 tables, how would i update the all the Null values with new values from another table into the that tempd table using store procedure. Thanks for these good tutorials
michael,
I hope you have an opportunity to read this in the near future. I am currently enrolled in an sql database class at a local community college and your videos have been a life saver for me. please dont stop making these videos if you can help it as im sure they will benefit me and alot of others in the future. thank you so much for your videos and your time.
Thank you so much, Michael! I have experience with writing SQL queries and have been trying to further my knowledge by learning T-SQL and also learn how to create and edit stored procedures. I am hoping to use this new knowledge for a new job opportunity I am applying for, so again, thank you for your wonderful explanation and examples! I followed everything you said beautifully :)
I'm glad to hear they're helping you I'll try to keep them coming!
Nice one, very clear explanation.
Michael, I just found your video and agree strongly with rawkjawk. Thank you for your clear tutorial.
I enjoyed watching this video. Thanks for educating the community and appreciate your volunteer-ship. Keep producing some more videos. Especially make a mistake and correct the error and explain how it has ben fixed will attract audience.
Especially create some videos with tips and tricks may click your video hits more.
Thanks a lot
Hey Mike, any chance you would be able to do a video on triggers? Really enjoying your videos! Concise and very effective.
Thanks Michael, I really appreciate the way you teach - any chance of being able to download the sql files that correspond with the lessons?
If you search for the Fudgemart SQL video, you can find a link to the SQL file in the description.
LOL! @4:58 DUHH! Great Video!
How can I populate a column in (tempd table). the column having Null values returned from a left join query of 2 tables, how would i update the all the Null values with new values from another table into the that tempd table using store procedure. Thanks for these good tutorials
Michael, I tried to follow the link in Fudgemart SQL video, it doesn't work. Where else can I find the SQL scripts? Thanks.
what's the diff. between CREATE PROC. and ALTER PROC. at the beginning of the sp? thanks in advance.
Create - creates a new procedure
Alter - edits an existing procedure
Encapsulating business logic into stored procedures? MeThinks this is a Bad Idea :(
Why?
I understand the pros and cons of doing it but am interested in you ideas.