Multi Tables - 1 Drop Statement - SQL in Sixty Seconds 134

Let us learn how we can drop multiple tables in a single DROP statement in SQL Server.

0:00 Introduction
0:13 Real-world Scenario
0:25 Demo - Multi-tables Single Drop Statement
0:42 Client Conversation
1:10 Summary
1:27 Final Tip

#SQLServer #PerformanceTuning #SQLAuthority

[GautamSingh-wgwe]

Hello! I became your fan.
Your video helps me lot in my job.
Your every 60's video make me more confident in my SQL profile.
Thanks a lot sir.

[achilleskocaeli]

thanks Pinal, I did not know that. It was very useful

[ameychavan]

Nice video sir it helps when more than one temp tables present In stored procedure

[nitinsingh]

Hi pinal, can create a video on how effectively we align our SQL query and long store procedure.

[yogeshsawant]

Sir, Exists command not working in my SSMS. Error is Incorrect syntax near keyword if.

[nataschalaros]

Hi Pinal Dave, I have a question regarding with statements and execution plan. What if I put a complete table (select * from table) into a with statement and then use the with statement instead of the table itself in my query selection: is this better or worse for performance?

[martinrod]

Hi Pinal, it would be great if you could make videos about Visual Studio SQL server Data Tools (SSDT). greetings from Argentina

[laurenceneville]

Thanks, I have never heard this before. From what version of SQL server was this supported?

[FrancescoMantovani]

ah, I was working with multiple temp tables today, I feel so lucky

[___rnd]

Hi Pinal, Intro was super, please also tell us the difference of EXEC and SP_Executesql and their limitations. I read EXEC is prone to hacking, true? Thanks I'm advance.