You are one hundred percent the best spokesperson in the SQL SERVER programming skills understanding and practicing. Great work and wish to see more videos from you.
Hi Team, Thank you very much for all your videos on SQL, SSIS and SSRS, i have watched all of them and practiced a lot. Because of Wise Owl i have now got a good offer in a company as a SQL developer. Thanks Team for putting in the efforts for creating such knowledgeable videos.
This tutorial as well as your Cursors tutorial have been most helpful. Thank you for teaching me about Stored Procedures and Cursors. You took my stress level from high to low with your explanations. Great teacher, and a nice accent to follow!
Wow, your step-by-step teaching and explanations made it easy for me to understand my text book on stored procedure. The time is worth spend watching your tutorials, thank you very much. I bet you I will always come back for more of this.
Omg I'm doing an online double degree and these vids have helped me SO MUCH! everytime there's a new introduction in my course content I look up the matching video by you and then I understand it straight away then go breeze through my material. Before you I would read the same paragraph 7273392 times, so thankyou!!!
Congratulations for the content! I'm Brazillian and it's difficult for us (Brazillian people) find good explanations like this. Don't stop, please! rs
10 ปีที่แล้ว
Well, I'm Brazilian and I don't speak english and I understand just a little bit, but this video is very good and simple that I understood everything. Thank you Andrew Gould.
Your videos are very, very good for beginners like me. I have an online book subscription and also a paid online tutorial subscription, but neither was clear on the basics. I wish I had found your videos first, as they have cleared up a lot of confusion for me. Thanks!
You Know You Are Genius! Salute To You Sir! Your Videos answered lots of my questions. Please Keep sharing such videos. And please also cover some DBA task this will really help people who are at beginner level. You have watched all of your videos SSRS, SQL, VBA Excel. You are doing great job. You know people are charging too much money just to give such kind of teaching. I have spend in past lots of money. But the Things I knew from your video is Awesome Sir. Thanks you So Much. God Bless You
I am new to functions and stored procedures world. Still trying to understand the concept. Thank you for the video, your clear instructions and examples are very helpful.
Hello WiseOwl, I love all of your videos! My only suggestion is that when creating an sp that allows nulls is to use a coalesce in the where statement. For example: FilmRunTimeMinutes >= coalesce(@MinLength, FilmRunTimeMinutes) You keep making 'em I'll keep watching 'em
Thanks for your teaching. However, sorry that I don't understand when you populate this SP in SSRS, why the windows is Visual Studio not in SSRS Windows environment?
by the way, I use ms sql magn studio 2012. my tutor also pointed out I didn't approach to using parameter in SSRS right, because I need to use begin and end, put @type=1 and @type=2 in SP instead of the way you showed in the video. she wouldn't explain why. and I googled a lot information regarding SSRS, it invovles many terms including what my tutor showed me. I wonder why your demonstration is different.
When we pass a Stored Proc data set to SSRS, it doesn't seem to carry forward our NULL and Default settings for the parameters. Am I doing something wrong, or do we have to manually set the parameter all over again in SSRS?
please can you explain I have different tables I stored that table names in one table with th id relation and how to store one table data using stored procedure with two parameters like id,table
Hey Andrew, great tutorial, just trying to add some value here. To solve the issue of defaulting parameters to NULL e.g.@MinLength= Null, we can also use the following: FilmRunTimeMinutes >= COALESCE(@MinLength,FilmRunTimeMinutes) We use the Coalesce function, to say if it is Null then talk to itself, i.e. we coalesce it against itself to say hey if you are Null then just use yourself. The only issue I had was that I use this method for '>', since that won't return anything, so I used '>='. What do you think?
I am trying to learn SQL Server on my own and I came up with an exercise where I want to create a stored procedure that takes the inputs UserId and Password and I want to encrypt the password and insert the entries into the table. I have been stuck on how to use hashbytes like sha1 to encrypt the password. Do you have any tutorials explaining the hashbytes?
Am i unlucky to live in Turkey to be far take the courses ? :D Absolutely, you are a good teacher ! But, if i want to take one step further from this level, what is your offer for me, for anyone like me who are not living in UK ?
hi! I'm new to this area. I created a database named familyexpense. I did the SP with parameter like (@minmonth as int,@category as int) so I could use the way in your tutorial to execute for results. It only worked without putting @maxmonth because it showed no result under the report table columns, just blank. what's the matter? pls explain.
+Zack Taylor Hi there, Probably there is no matching records as per the input parameter values..Please check if the corresponding column has the declared parameter value or not..
Hi WiseOwl, all the tutorials are very good, i am learning many thing from ur videos thanks for uploading. I have one doubt in Store procedure parameters,Like u said i have created store procedure with parameter @minLength=NULL,@maxLength NULL,@title same like in video.and also create report with dataset as store procedure so when i ran that report why i need to give values for all 3 parameters if i left any parameter(@minLength,@maxLength) it will give me error that u should pass the value to the parameter but we have mention condition in sp for Null values.please suggest me. Thanks & regards, Rucha Thakurdesai
End of 2024 and still best tutorial on TH-cam
Wiseowl Tutorials, probably still the best on TH-cam today.
This is an awesome series. I've been having some troubles with t-sql, but your tutorials are really clear to me. Thank you very much!
Great video. I love how you take your time and explain the process as you teach, step by step instruction and the calmness in your voice. Wonderful!
Thank you so much!
Thanks for sharing you're knowledge. What a calm, great and soft voice!
You are one hundred percent the best spokesperson in the SQL SERVER programming skills understanding and practicing. Great work and wish to see more videos from you.
Very smooth delivery. You have a gift for passing on knowledge.
Thank you for sharing.
Hi Team,
Thank you very much for all your videos on SQL, SSIS and SSRS, i have watched all of them and practiced a lot. Because of Wise Owl i have now got a good offer in a company as a SQL developer.
Thanks Team for putting in the efforts for creating such knowledgeable videos.
Very good tutorial. You voice was clear, well paced and the structure of the session well put together.
Thanks Dane, glad you enjoyed it!
Andrew, you are a superb teacher. I have been wanting to learn about Stored Procedures, and your course is the best I have watched by far. Thank you!
There aren’t enough words or ways to express how grateful I’m watching your videos. Thank you so much for making these videos...THANKS 🙏🙏🙏🙏🙏
This tutorial as well as your Cursors tutorial have been most helpful. Thank you for teaching me about Stored Procedures and Cursors. You took my stress level from high to low with your explanations. Great teacher, and a nice accent to follow!
Wow, your step-by-step teaching and explanations made it easy for me to understand my text book on stored procedure. The time is worth spend watching your tutorials, thank you very much. I bet you I will always come back for more of this.
Omg I'm doing an online double degree and these vids have helped me SO MUCH! everytime there's a new introduction in my course content I look up the matching video by you and then I understand it straight away then go breeze through my material. Before you I would read the same paragraph 7273392 times, so thankyou!!!
Congratulations for the content! I'm Brazillian and it's difficult for us (Brazillian people) find good explanations like this.
Don't stop, please! rs
Well, I'm Brazilian and I don't speak english and I understand just a little bit, but this video is very good and simple that I understood everything. Thank you Andrew Gould.
I liked the way you have explained in all the sql server lectures
Your videos are very, very good for beginners like me. I have an online book subscription and also a paid online tutorial subscription, but neither was clear on the basics. I wish I had found your videos first, as they have cleared up a lot of confusion for me. Thanks!
The entire tutorial is precisely well thought out and nicely presented. Thanks WiseOwl once again......
I love you. wow! what a clear and objective explanation :) dont stop your tutorials please
These videos are really helpful. Feel like I understand more than my class teacher. Thanks for sharing!!!
This is EXTREMELY helpful. So well explained and simply taught. Thank you so much God bless you for this incredible free tutorial.
You're very welcome, Fahim! Thank you for watching and taking the time to leave a comment!
Outstanding in term of simplicity, clear , and concise. Thank you.
Wish I would've come here long back, but I am sure your session will take me beyond..
Thank you for this video.
It is so useful and save lot of time that could be spent in research!
Happy to hear you found it useful Justin, thanks for watching!
Excellent video! covers all bases and simplifies the explanations of each property!
All online courses should be like this!!!!
you are the best teacher. thank you for clear information
You're very welcome, thanks for watching!
BEST SQL TUTORIALS in the world thanks u very much guys
I enjoyed this video. I encourage newbee's to MSSQL to watch.
Thanks a lot.
Thank you for the videos. You are excellent teacher! You make it easy to understand.
You Know You Are Genius! Salute To You Sir! Your Videos answered lots of my questions. Please Keep sharing such videos. And please also cover some DBA task this will really help people who are at beginner level. You have watched all of your videos SSRS, SQL, VBA Excel. You are doing great job. You know people are charging too much money just to give such kind of teaching. I have spend in past lots of money. But the Things I knew from your video is Awesome Sir. Thanks you So Much. God Bless You
Your Tutorials are VERY GOOD! Super explanations!
I am new to functions and stored procedures world. Still trying to understand the concept. Thank you for the video, your clear instructions and examples are very helpful.
I just have to say, i better understand how to use SP after these tutorials then after watching those on Lynda.com. Great job!
You made it look so easy! Thank you for sharing!
You're very welcome, thanks for watching!
Great tutorial, love your teaching style
Ur the BEST TEACHER i ever had.
Thank u Sir...
***** I'm agree with you, it's easy to understand and very useful.
Awesome tutorial, beautifully explained
Thanks for watching Salim!
@@WiseOwlTutorials Thank you very much
Thanks for such a great video on SQL Procedure!
You're wise indeed. That was very helpful
I enjoy your videos, a lot can be learnt !! Appreciate your work. Thanks.
simply perfect Presentation... Thanks for your time
Excellent video. Easy to understand and follow. Thanks!
still useful in 2017, I hope he will add more videoes to these series. Nice work! :P
Finally... someone speaks English.
Thanks a lotttt ... your tutorials are fantastic!!!
Thank you for the tutorials. Well done, helped me a lot.
Thank you for doing this.
Nice and helpful (as always :) ). Many thanks!
Sir, This video was great. Thank you
Thank you for watching, Hammad!
This was very helpful. Thank you!
Hi. is the "Reporting Services" you mentioned at 18:55, part of Server Management Studio? How do I access it? Thanks!
this is great stuff. Thank you
Hello WiseOwl,
I love all of your videos!
My only suggestion is that when creating an sp that allows nulls is to use a coalesce in the where statement. For example:
FilmRunTimeMinutes >= coalesce(@MinLength, FilmRunTimeMinutes)
You keep making 'em
I'll keep watching 'em
Excellent! Very helpful!
This has helped me so much !!! Thank you so much
Thanks for this! I watched it muted and still grasped everything.
lol No.. :D others need it.
Thank you for these.
very very good simple to understand
I love your videos!!! Thank you
awesome tutorial! Thank u
Thanks so much!
thank you wise owl!
Very helpful. Thank you.
thank you very match awesome tuto
You're welcome, Karim! Thank you for watching!
yes..thanq
Excellent video !! How will I know a store procedure has how many optional parameters without looking at the codes or statements?
You made my day man ;) thanks
Thanks for your teaching. However, sorry that I don't understand when you populate this SP in SSRS, why the windows is Visual Studio not in SSRS Windows environment?
very well explained
Hi,
Love the videos,
I was just wondering if you could use a list or array as a parameter and how you would do that?
Loved it again :-)
very good lesson thank you very much
great work!
Awesome video
At the timestamp 13:32, can you also do it like this: FilmName LIKE @Title + '%'
is it possible to get multiple values, cascading of parameters when we fetches the data into reports by using stored procedure?
simply superb. thanks
Thank you very much! This helps :)
by the way, I use ms sql magn studio 2012. my tutor also pointed out I didn't approach to using parameter in SSRS right, because I need to use begin and end, put @type=1 and @type=2 in SP instead of the way you showed in the video. she wouldn't explain why. and I googled a lot information regarding SSRS, it invovles many terms including what my tutor showed me. I wonder why your demonstration is different.
Really nice video's
I love you thanks mate!
[nice accent as well]
When we pass a Stored Proc data set to SSRS, it doesn't seem to carry forward our NULL and Default settings for the parameters.
Am I doing something wrong, or do we have to manually set the parameter all over again in SSRS?
this is greatestuff one..thank u..
please can you explain I have different tables I stored that table names in one table with th id relation and how to store one table data using stored procedure with two parameters like id,table
Very Helpful. . . . :)
Hey Andrew, great tutorial, just trying to add some value here.
To solve the issue of defaulting parameters to NULL e.g.@MinLength= Null, we can also use the following:
FilmRunTimeMinutes >= COALESCE(@MinLength,FilmRunTimeMinutes)
We use the Coalesce function, to say if it is Null then talk to itself, i.e. we coalesce it against itself to say hey if you are Null then just use yourself.
The only issue I had was that I use this method for '>', since that won't return anything, so I used '>='.
What do you think?
Hello, thanks to your videos! How can I use IN with a non integer parameter? thank you
I am trying to learn SQL Server on my own and I came up with an exercise where I want to create a stored procedure that takes the inputs UserId and Password and I want to encrypt the password and insert the entries into the table. I have been stuck on how to use hashbytes like sha1 to encrypt the password. Do you have any tutorials explaining the hashbytes?
very useful.
Thanks for sharing
great work..thanks
Am i unlucky to live in Turkey to be far take the courses ? :D
Absolutely, you are a good teacher !
But, if i want to take one step further from this level, what is your offer for me, for anyone like me who are not living in UK ?
hi! I'm new to this area. I created a database named familyexpense. I did the SP with parameter like (@minmonth as int,@category as int) so I could use the way in your tutorial to execute for results. It only worked without putting @maxmonth because it showed no result under the report table columns, just blank. what's the matter? pls explain.
+Zack Taylor Hi there, Probably there is no matching records as per the input parameter values..Please check if the corresponding column has the declared parameter value or not..
can we use Stored procedures in PowerBI?
Yes! You need to provide the database name and use the Advanced options to enter a SQL query such as:
EXEC myStoredProc
I hope it helps!
Do you have any video demonstrating SQL injection or protect my program from hackers?
Hi WiseOwl,
all the tutorials are very good, i am learning many thing from ur videos thanks for uploading.
I have one doubt in Store procedure parameters,Like u said i have created store procedure with parameter @minLength=NULL,@maxLength NULL,@title same like in video.and also create report with dataset as store procedure so when i ran that report why i need to give values for all 3 parameters if i left any parameter(@minLength,@maxLength) it will give me error that u should pass the value to the parameter but we have mention condition in sp for Null values.please suggest me.
Thanks & regards,
Rucha Thakurdesai
i have one question plz
what type of report are you using??
***** thank you so much this report is awesome .. thanks a lot
Very helpful Thanks :-D
Thank you Andrew,You are always beautiful
:D thank you!