Hi, thank you very much taking time to answer this question. As, I am receiving lot of questions everyday from our youtube users, I am finding it extremely difficult to answer all the questions in time. With your help I am confident, we will be able to answer most questions in time. Appreciate your time and effort. God bless you.
Thank you very much for taking time to give feedback. In the description of this video, I have included the link for ASP .NET, C#, and SQL Server playlists. All the videos are arranged in logical sequence in these playlists, which could be useful to you. Please share the link with your friends who you think would also benefit from them. If you like these videos, please click on the THUMBS UP button below the video. For email alerts, when new videos are uploaded, you may subscribe to my channel.
Thank you very much for taking time to give feedback. This means a lot. I am very glad you found the videos useful. I have organised all the Dot Net & SQL Server videos in to playlists, which could be useful to you ua-cam.com/users/kudvenkatplaylists?view=1&sort=dd If you need DVDs or to download all the videos for offline viewing please visit www.pragimtech.com/kudvenkat_dvd.aspx Slides and Text Version of the videos can be found on my blog csharp-video-tutorials.blogspot.com Tips to effectively use my youtube channel. ua-cam.com/video/y780MwhY70s/v-deo.html If you want to receive email alerts, when new videos are uploaded, please subscribe to my youtube channel. ua-cam.com/users/kudvenkat If you like these videos, please click on the THUMBS UP button below the video. May I ask you for a favor. I want these tutorials to be helpful for as many people as possible. Please share the link with your friends and family who you think would also benefit from them. Good Luck Venkat
As per your lesson i have created stored procedure for the purpose of avoid the slow pwrformance in sql...Even i am facing the same problem after the creation of stored procedure..Please help me...I am struggling with this Past 10 days....
I enjoyed watching this video. I suggest all developers to watch. Conceptually explained very clear. Also at the end mentioned interview questions on the topic. Dear Venkat I think after every video you make please include probable interview questions if possible that makes very good sense. Thanks a bunch
Try to correct you sir well explained but in case of global temp table if you create a table in one connection and that connection is closed it will dropped automatically and you can't select query in second open connection.
mrudang dalal sometimes when we have subquery joins in our SQL query,it tends to take more time...so to get better performance we use this temp table and use it in join directly rather than using subquery
@@krishnendrabhattacharyya4609 is that the case. Then we are inserting values into temporary table manually. How come it resolve the problem when we had more values to insert. Everytime we have to do that right?
Hi Ben, you can't access the table #personaldetails from another query window. In the above query, we are not querying the table #personaldetails rather we are accessing the sysobjects table which stores information about temporary tables and some other info. We can access sysobjects table from any connection.
Hi venkat, I really appreciate your effort in sql server blogs and videos. i have learned a lot from videos for SQL server and we used in office work that is very much helpful. I have a question for you regarding sql query. if you could help me it would be grateful. One of interview ask me and i am not able to answer this. Question: Create a table procedure as per user requirement, Please follow the instruction is given below. Instruction: User can give multiple columns (Column 1, 2, 3, or 4 and So on), It should be dynamic column. Main Table A B C D E F G H Output: if user put two columns then: Column 1 Column 2 A B C D E F G H Output: if user put three columns then: Column 1 Column 2 Column 3 A B C D E F G H
Hi Venkat, very nice explanation. Could you please clarify the below question. The Global Temporary table will be destroyed as soon as the connection in which it is created closes. I don't think it will be there till the last connection referencing is closed.
Hi Saliha - I think table variable is discussed in the following video, but not 100% sure on the level of detail. Please check it out when you have some time. Hope you will find it useful. ua-cam.com/video/P3uBWp0qvlo/v-deo.html&index=101&list=PL08903FB7ACA1C2FB Here is the link to the full SQL Server playlist. ua-cam.com/play/PL08903FB7ACA1C2FB.html
If we have a stored proc that contains an insert into ##temp_table statement, do we need to add a line to drop the ##temp_table first before the actual insert into statement? I need to schedule the SP to run everyday. Thanks in advance.
I thought if two connections were open .We can't drop a global temp table from one of the connections unless it is the last connection .But I was able to delete global temp table from one of the connections even though another connection was still open . ?
Hi i just want to know what happen when 1 global table is access by 2 connection at the same time and in both the connection update the global table so data is override or not in global table
Hello Venkat, I can access the local temporary from another connection when I copy and paste Select name from Tempdb..sysobjects Where name like '#persondetails%' to the new query window, why is this? You are amazing in the UK too ! Ben
Hello Sir, i created store procedure with global temp table, and when i execute this store procedure in sql server , i can see the ##mytable in tempdb. but when execute same store procedure from web application then i'm unable to locate ##mytable in tempdb. but i'm able to retrieve data from ##mytable in web application.
I wish ALL the tutorials on UA-cam were this comprehensive and yet simple to understand. Excellent work. Thanks for this.
Hi, thank you very much taking time to answer this question. As, I am receiving lot of questions everyday from our youtube users, I am finding it extremely difficult to answer all the questions in time. With your help I am confident, we will be able to answer most questions in time. Appreciate your time and effort. God bless you.
Google'd across many websites, but none of them are clear than your tutorials... Best in Best
Thank you very much for taking time to give feedback. In the description of this video, I have included the link for ASP .NET, C#, and SQL Server playlists. All the videos are arranged in logical sequence in these playlists, which could be useful to you. Please share the link with your friends who you think would also benefit from them. If you like these videos, please click on the THUMBS UP button below the video. For email alerts, when new videos are uploaded, you may subscribe to my channel.
Bro, You are genius, Thank you so much, I read many articles about this, but i did not get clear idea. Now i got.
Way of explanation is excellent and highly informative. Wouldn't get any better than this. Thanks a ton Sir !!!
Most underrated sql course in youtube why these videos have less likes. i am learning easy as a beginner thankyou so much sir.
wow it has been 10 years ago. thanks for great work!
The best tutorial on MS SQL server. Thank you
absolutely simple and clear .. greatest turorials on youtube.. thank you
Thanks for the video.. It's pretty clear explanation.. Keep posting more videos on sql...
Very well explained. Love your videos. you are blessed with the ability to explain in a way that is easy to understand. Thank you!
Excellent Simply Excellent........I am Impressed
The way of explanation is too good,i would like to watch all your SQL videos and learn SQL...Thanks a ton sir!!!
Thank you very much for taking time to give feedback. This means a lot. I am very glad you found the videos useful.
I have organised all the Dot Net & SQL Server videos in to playlists, which could be useful to you
ua-cam.com/users/kudvenkatplaylists?view=1&sort=dd
If you need DVDs or to download all the videos for offline viewing please visit
www.pragimtech.com/kudvenkat_dvd.aspx
Slides and Text Version of the videos can be found on my blog
csharp-video-tutorials.blogspot.com
Tips to effectively use my youtube channel.
ua-cam.com/video/y780MwhY70s/v-deo.html
If you want to receive email alerts, when new videos are uploaded, please subscribe to my youtube channel.
ua-cam.com/users/kudvenkat
If you like these videos, please click on the THUMBS UP button below the video.
May I ask you for a favor. I want these tutorials to be helpful for as many people as possible. Please share the link with your friends and family who you think would also benefit from them.
Good Luck
Venkat
As per your lesson i have created stored procedure for the purpose of avoid the slow pwrformance in sql...Even i am facing the same problem after the creation of stored procedure..Please help me...I am struggling with this Past 10 days....
sir if possible please share your e mail ID or contact number...Please
AWESOME. Concept explained crystal clear. I would recommend others to watch.
Thanks a bunch
I enjoyed watching this video. I suggest all developers to watch. Conceptually explained very clear. Also at the end mentioned interview questions on the topic.
Dear Venkat I think after every video you make please include probable interview questions if possible that makes very good sense.
Thanks a bunch
Great Teacher Sir Venkat. Amazing Methodology with great knowldge
Simple way to illustrate the concepts. Thanks for sharing this playlist on SQL. I find videos far useful than reading books.
Hi Venkat, thank you so much for making these videos and sharing your knowledge. You are doing an awesome job. God Bless you too :)
Still there are no such details I found in another channels..you are the best @kudvenkat sir 💐. Thankyou so much sir
Excellent And Good videos yet simple Learning to understanding.Thanks for this.
This video helped me a lot....Very informative...
You are clear and easy to understand thank you sir.
You are the best!!!! 🙏🙏🙏🙏🙏
This video is very helpful! Thank you very much!
A really really really good explanation, thanks a lot!.
i'll continue all the videos ... you are awesome :) THANK YOU
It is nice tutorial to enhance your knowledge..
very useful video! Thanx Venkat!
Very nice sir!! My Pranams to you
Thank you sir........its very very helpful..
Thank you for a wonderful session.
Try to correct you sir well explained but in case of global temp table if you create a table in one connection and that connection is closed it will dropped automatically and you can't select query in second open connection.
+Sajid Hameed thanks for the info i checked it programatically ur right global temp table also gets delted.
Very clear and easy to understand.
Awesome explanation. Great work Venkat!!
Great job Venkat ! easy to follow. :)
nicely explained..good communication
Hi, here one thing is not clear is, what is the need to having Temporary tables . Can you explain the use of it ?
mrudang dalal sometimes when we have subquery joins in our SQL query,it tends to take more time...so to get better performance we use this temp table and use it in join directly rather than using subquery
@@krishnendrabhattacharyya4609 is that the case. Then we are inserting values into temporary table manually. How come it resolve the problem when we had more values to insert. Everytime we have to do that right?
Thank you sir! Much appreciated.
It seems very easy, i like your all videos. but It will better if you can keep less duration of video.
Indeed - Great explanation...
thank you very much ❤️🌼
Hi Ben, you can't access the table #personaldetails from another query window. In the above query, we are not querying the table #personaldetails rather we are accessing the sysobjects table which stores information about temporary tables and some other info. We can access sysobjects table from any connection.
Hi venkat, I really appreciate your effort in sql server blogs and videos. i have learned a lot from videos for SQL server and we used in office work that is very much helpful.
I have a question for you regarding sql query. if you could help me it would be grateful. One of interview ask me and i am not able to answer this.
Question: Create a table procedure as per user requirement, Please follow the instruction is given below.
Instruction: User can give multiple columns (Column 1, 2, 3, or 4 and So on), It should be dynamic column.
Main Table
A
B
C
D
E
F
G
H
Output: if user put two columns then:
Column 1 Column 2
A B
C D
E F
G H
Output: if user put three columns then:
Column 1 Column 2 Column 3
A B C
D E F
G H
Awesome Sir ji ...
It looks like you have to enter your own data. How do you create a table with the data that is already in the database? Thank you!
Hi Venkat, very nice explanation. Could you please clarify the below question. The Global Temporary table will be destroyed as soon as the connection in which it is created closes. I don't think it will be there till the last connection referencing is closed.
Thank you for your clear explanation
i refer your video if unable to understand the concepts any where tq
very well explained sir (y)
Nicely explained.
is there any video related to table variable on your channel?
Hi Saliha - I think table variable is discussed in the following video, but not 100% sure on the level of detail. Please check it out when you have some time. Hope you will find it useful.
ua-cam.com/video/P3uBWp0qvlo/v-deo.html&index=101&list=PL08903FB7ACA1C2FB
Here is the link to the full SQL Server playlist.
ua-cam.com/play/PL08903FB7ACA1C2FB.html
thanks sir...
If we have a stored proc that contains an insert into ##temp_table statement, do we need to add a line to drop the ##temp_table first before the actual insert into statement? I need to schedule the SP to run everyday. Thanks in advance.
Yes better do that, otherwise it will create a new temptable everyday which is not a good thing.
where is the video about table variable ?pls let me know ?
I thought if two connections were open .We can't drop a global temp table from one of the connections unless it is the last connection .But I was able to delete global temp table from one of the connections even though another connection was still open . ?
Hi i just want to know what happen when 1 global table is access by 2 connection at the same time and in both the connection update the global table so data is override or not in global table
Thanks, Sir
Hello Venkat, I can access the local temporary from another connection when I copy and paste
Select name from Tempdb..sysobjects
Where name like '#persondetails%'
to the new query window, why is this?
You are amazing in the UK too ! Ben
Did you found the answer to this question.
Althought its not like accessing but we are able to list down from other connection too
Hello sir, really good session. I have a question from this, can we have both schema binding and encryption for a function?
Hi Dineash, Yes you can have both. Make use of WITH SCHEMABINDING, ENCRYPTION while creating or altering function
Hello Sir,
i created store procedure with global temp table, and when i execute this store procedure in sql server , i can see the ##mytable in tempdb. but when execute same store procedure from web application then i'm unable to locate ##mytable in tempdb. but i'm able to retrieve data from ##mytable in web application.
Do we need any permissions to create a temporary table. We QA are general given read only access to query data.
good explanation sir
where is the video MAGIC tables ?pls upload that video in one interview ask that question to me....please upload that one..
temp tables can be widely used in stored procedures
when do we need these temporary tables?
Temp tablets and magical tablets are the same or different 🤔
thank u so much
Hello' i don't clearly understand of temporary table, in which area we use temp tables.
Thank you
How can I update the data in the table without affecting the base tables
When do we use one over the other?
Can you please explain magic tables concept?
thanks
BEST.
Nice :-0)
what are Sql Jobs ?
So close to 666 likes 😱
Hello😂😂
thank you
Thanks
Thank you