28 Create stored procedure in sql server with input and output parameters

No video

28 Create stored procedure in sql server with input and output parameters

Рет қаралды 4,830

Күн бұрын

Create stored procedure in sql server with input and output parameters
Download the file\script used in the Video from below link
drive.google.c...
Download and restore adventureworks database to SQL 2019: • 06 Download and restor...
How to create stored procedure in SQL Server: • 27 How to create store...
SQL Server: • SQL Server
SQL Server Developer Interview questions: • SQL Server Questions
Create stored procedure in sql server with input and output parameters
How do you pass input and output parameters in stored procedure?
How do you execute a stored procedure with in and out parameters in SQL Server?
Does stored procedure support input and output parameters?
How do I pass an output parameter to a SQL stored procedure?
If you have any questions or suggestions please comment on the video or write to me at “aqil33@gmail.com”

Пікірлер: 23

@Loknath7702 2 жыл бұрын

Thanks for making Stored procedure in SQL Server.. please make a real time usefull concepts in SQL Server. Most of the people waiting for SQL server concepts.

@learnssis 2 жыл бұрын

Sure Loknath will make more videos on SQL Server and will try to use make real time useful concepts.

@Loknath7702 2 жыл бұрын

Thank you.. most of the real time of SQL server is about stored procedures & functions only.. hope you will make most of the videos on that..

@learnssis 2 жыл бұрын

@@Loknath7702 Sure will do.

@sahilnaik3585 Жыл бұрын

thanks a lot sir..got my doubt cleared

@dimpy885 2 жыл бұрын

Hats off to you , you made output procedure easy for me now

@learnssis 2 жыл бұрын

Nice to hear from you Dimpy that it helped you.

@lazygamer8760 2 жыл бұрын

Thank you so much sir.

@learnssis 2 жыл бұрын

You are most welcome Lazy Gamer.

@kumarg2580 2 жыл бұрын

How do we convert bigint into int in SQL query? Do we need stored Proc?

@learnssis 2 жыл бұрын

We can use either cast or convert method, we don't need stored proc. Below 2 queries will convert the data to int from another type, it can be bigint of varchar or any other type select cast(somevalue as int) as NewColumn from tablename select convert(int, somevalue) as NewColumn from tablename select cast(100 as int) select convert(int, 100)

@kumarg2580 2 жыл бұрын

@@learnssis I get this message when I cast and tried to insert it into int column. Arithmetic overflow error converting expression to data type int

@learnssis 2 жыл бұрын

@@kumarg2580 It means there is some data which can't be converted to int.

@Rameshpowervlogs 2 жыл бұрын

Sir there is any opportunity in msbi ??? No cals are coming y sir

@learnssis 2 жыл бұрын

I don't know about the opportunities in msbi. You would need to check the respected web sites where you can get calls. Sorry for that.

@Rameshpowervlogs 2 жыл бұрын

@@learnssis tanq so much

@sreenathreddykurthi7681 Жыл бұрын

Can we use print @nationallidentifier to fetch output?

@learnssis Жыл бұрын

I don't think it will work, we would need to use select here.

@naveenboya4469 2 жыл бұрын

Please make video on fact tables and dim tables

@aanchalsrivastava8550 2 жыл бұрын

For mysql also

@learnssis 2 жыл бұрын

Sure Aanchal I will try to make videos on mysql as well. Actually I noticed whenever I make a video on mysql, I get very low views on the video thus I am trying to make videos on SQL and SSIS. In between I will try to put a mysql video as well but for now they will be very minimum. Sorry about that.

@aanchalsrivastava8550 2 жыл бұрын

@@learnssis that should not stop you from making the video people will definitely search for mysql as it is also becoming more used in professional front and with good explanations in video related to mysql that will help people a lot.

@learnssis 2 жыл бұрын

@@aanchalsrivastava8550 Yeah I will try to make videos on mysql as well.