SQL Server Programming Part 2 - Stored Procedure Parameters

[@uow513]

Wiseowl Tutorials, probably still the best on KZbin today.

[@RobinVandaele]

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!

[@anawadtom6011]

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!

[@WiseOwlTutorials]

Thank you so much!

[@madhusudhanreddyt2838]

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.

[@omkarsakhalkar4158]

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.

[@juancardona2491]

Thanks for sharing you're knowledge. What a calm, great and soft voice!

[@tinikapasinetti1]

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!!!

[@ngozimonyei2047]

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.

[@jesse6327]

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!

[@Abdikaaf]

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 🙏🙏🙏🙏🙏

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.

[@millerdane]

Very good tutorial. You voice was clear, well paced and the structure of the session well put together.

[@WiseOwlTutorials]

Thanks Dane, glad you enjoyed it!

[@Ambasabi]

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!

[@felipemv13]

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

[@judithm.p4719]

Very smooth delivery. You have a gift for passing on knowledge. Thank you for sharing.

[@danielabregoify]

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!

[@sudarshankumar6890]

I liked the way you have explained in all the sql server lectures

[@mohammadmonirhossain6214]

The entire tutorial is precisely well thought out and nicely presented. Thanks WiseOwl once again......

[@Rational108]

Wish I would've come here long back, but I am sure your session will take me beyond..

[@virgiliouamusse325]

I love you. wow! what a clear and objective explanation :) dont stop your tutorials please

[@fahimimtiaz4532]

This is EXTREMELY helpful. So well explained and simply taught. Thank you so much God bless you for this incredible free tutorial.

[@WiseOwlTutorials]

You're very welcome, Fahim! Thank you for watching and taking the time to leave a comment!

[@TheChibisu]

All online courses should be like this!!!!

[@krismaly]

I enjoyed this video. I encourage newbee's to MSSQL to watch. Thanks a lot.

[@udara5966]

BEST SQL TUTORIALS in the world thanks u very much guys

[@justinbanza4751]

Thank you for this video. It is so useful and save lot of time that could be spent in research!

[@WiseOwlTutorials]

Happy to hear you found it useful Justin, thanks for watching!

[@ramatadoumbia7944]

These videos are really helpful. Feel like I understand more than my class teacher. Thanks for sharing!!!

[@ced4298]

Excellent video! covers all bases and simplifies the explanations of each property!

[@anhseavitt7477]

Outstanding in term of simplicity, clear , and concise. Thank you.

[@dawanathomas3234]

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.

[@halisyilmaz6967]

you are the best teacher. thank you for clear information

[@WiseOwlTutorials]

You're very welcome, thanks for watching!

[@brotaque]

I just have to say, i better understand how to use SP after these tutorials then after watching those on Lynda.com. Great job!

[@subhashkomy]

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

[@sarunkuriakose7512]

Ur the BEST TEACHER i ever had. Thank u Sir...

[@TheBitles]

***** I'm agree with you, it's easy to understand and very useful.

[@111Lky]

Thank you for the videos. You are excellent teacher! You make it easy to understand.

[@NishanSaliya]

Your Tutorials are VERY GOOD! Super explanations!

[@ItsWithinYou]

You made it look so easy! Thank you for sharing!

[@WiseOwlTutorials]

You're very welcome, thanks for watching!

[@speculator2000]

Great tutorial, love your teaching style

[@salimtalal4696]

Awesome tutorial, beautifully explained

[@WiseOwlTutorials]

Thanks for watching Salim!

[@salimtalal4696]

@@WiseOwlTutorials Thank you very much

[@christianrodier3381]

You're wise indeed. That was very helpful

[@BlaQavelli]

Finally... someone speaks English.

[@vurimindikalyan]

simply perfect Presentation... Thanks for your time

[@sneharaomolugu2624]

I enjoy your videos, a lot can be learnt !! Appreciate your work. Thanks.

[@stackflow4007]

still useful in 2017, I hope he will add more videoes to these series. Nice work! :P

[@FoodWithKamalMohali]

Thanks for such a great video on SQL Procedure!

[@TiaanHugovanderMerwe]

Thank you for doing this.

[@TysonKamak]

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

[@Pingsmingu]

very very good simple to understand

[@hammadazaz1229]

Sir, This video was great. Thank you

[@WiseOwlTutorials]

Thank you for watching, Hammad!

[@christinlal]

Thank you for these.

[@MrRandyKelley]

Excellent video. Easy to understand and follow. Thanks!

[@YuXingSong]

awesome tutorial! Thank u

[@WiseOwlTutorials]

Thanks so much!

[@swan_e]

Excellent! Very helpful!

[@stevenanderson7178]

this is great stuff. Thank you

[@adi_u]

Thanks a lotttt ... your tutorials are fantastic!!!

[@florenciasalas6215]

I love your videos!!! Thank you

[@gta4sk8]

This was very helpful. Thank you!

[@CyberAbyss007]

Thank you for the tutorials. Well done, helped me a lot.

[@123246265245]

thank you wise owl!

[@antonaverianov6851]

This has helped me so much !!! Thank you so much

[@whatisdneed]

Very helpful. Thank you.

[@bogdanudovicic391]

Nice and helpful (as always :) ). Many thanks!

[@Klesx]

Thanks for this! I watched it muted and still grasped everything.

[@Klesx]

lol No.. :D others need it.

[@karimmr8433]

thank you very match awesome tuto

[@WiseOwlTutorials]

You're welcome, Karim! Thank you for watching!

[@AshfaaqCurimbaccus]

very helpful tuto !

[@emarkets1009]

Hi. is the "Reporting Services" you mentioned at 18:55, part of Server Management Studio? How do I access it? Thanks!

[@grimfandango1]

great work!

[@devips5102]

very well explained

[@DrSatti]

simply superb. thanks

[@KalugampitiyaJayakody]

very good lesson thank you very much

[@vincentpoon9394]

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?

[@andyle3016]

At the timestamp 13:32, can you also do it like this: FilmName LIKE @Title + '%'

[@chinazac]

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.

[@techie53d]

Awesome video

[@Bhagg-gt2pr]

You made my day man ;) thanks

[@anilmanuka2052]

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

[@sureshmaharjan511]

Excellent video !! How will I know a store procedure has how many optional parameters without looking at the codes or statements?

[@ramyagv5676]

Thank you very much! This helps :)

[@eshwarchow9]

yes..thanq

[@huqsami]

Loved it again :-)

[@prabhakarane3757]

this is greatestuff one..thank u..

[@gisrouaryanzad4827]

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?

[@GiuseppeSerraonline]

Thanks for sharing

[@aviadshalom66]

I love you thanks mate! [nice accent as well]

[@ethelpalomino]

Hello, thanks to your videos! How can I use IN with a non integer parameter? thank you

[@sreenuksr]

Really nice video's

[@rockysingh5128]

very useful.

[@revathirayar2600]

great work..thanks

[@ayinggniya3437]

Very Helpful. . . . :)

[@kamran_desu]

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?

[@eshwarchow9]

is it possible to get multiple values, cascading of parameters when we fetches the data into reports by using stored procedure?

[@chinazac]

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.

[@vurimindikalyan]

+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..

[@rajkumarrajan8059]

can we use Stored procedures in PowerBI?

[@WiseOwlTutorials]

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!

[@yucelozyazgan]

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 ?

[@ramyagv5676]

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?

[@kamran_desu]

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?

[@ario195]

i have one question plz what type of report are you using??

[@ario195]

***** thank you so much this report is awesome .. thanks a lot

[@krismaly]

Do you have any video demonstrating SQL injection or protect my program from hackers?

[@tomboi88]

Very helpful Thanks :-D

[@fadwa2413]

Thank you Andrew,You are always beautiful

[@WiseOwlTutorials]

:D thank you!

[@RuchaThakurdesai]

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