76 Create a stored procedure for book management system in sql server

preview_player
Показать описание
Create a stored procedure for book management system

Create a stored procedure for book management system
Create a stored procedure for real life problem
What is stored procedure with real time example?
How to create a stored procedure in SQL step by step?
What are the scenarios under which you would use a stored procedure?

Рекомендации по теме
Комментарии
Автор

Hi akhil Ahmed please upload different stored procedure that would help us in realtime projects while working on sp to know each and everystatement and all give us more confidence to build the sp.

rameshsanipayavlogs
Автор

Sir ..i really want to get to know that how i can become good at sql how i can do practice on it you have very good experience on it so plz tell me in beginning how you used to do practice on it ....

amanbodele
Автор

HI Aquil if possible Please make a video on UDF's with real time scenario and using Proc inside a proc with an real time example

_Rajuk
Автор

When you update Books, in the first set available books you are already subtracting 1 (one) book from the current transaction, in the next line why are you using available copies - 1 again? hasn't Available copies been updated already in the line before?

juanodonnell
Автор

There is a lot of talk about avoiding nvarchar in the database, in the examples did you create it with nvarchar for any specific reason or just because it is just an example?

PedroHenrique-idbk
Автор

Sir, kya aap ssis ki training de skte h mujhe Hindi me

ankitsaxena