Dynamic SQL is SQL query that is executed at runtime. I hope the following is not a silly question. But when is it that we need this functionality ? i.e., when do we need some codes to be executed at runtime ?
Think of user input. Maybe they’re a user with an account that’s looking for his or her grades for the semester. User inputs would be name, password. Maybe later it asks year, semester etc etc. it’s useful for when you want the user to input specific parameters
Thank you for the video. Love the content.
Thank you
@@LearnatKnowstar can u share any material
Dynamic SQL is SQL query that is executed at runtime.
I hope the following is not a silly question. But when is it that we need this functionality ? i.e., when do we need some codes to be executed at runtime ?
Think of user input. Maybe they’re a user with an account that’s looking for his or her grades for the semester. User inputs would be name, password. Maybe later it asks year, semester etc etc. it’s useful for when you want the user to input specific parameters
Show one example how to create tables dynamically in sql
Thank you for another useful video. Maybe in the future you will do another videos regarding dynamic Sql.Please.
Yes, soon
@@LearnatKnowstar thank you so much
very well explained.
Glad it was helpful!
In the statement "execute sp_executesql", should I assume that you've already created a Stored Procedure beforehand with the name "sp_executesql"?
sp_executesql is if i m not wrong by default in Sql Server.
sp_executesql is a system stored procedure available by default in SQL Server.
Awesome
Thank you
PCS global tech brought me here XD
Thanks Ravi ;)
Hi i want to learn sql from scratch will u help me on that
Sure. Please Stay tuned for a beginners SQL tutorial coming soon!