#7. MySQL: Drop & Truncate | MySQL 2023

[@COD_MW007]

Sir, one doubt I have here, when we use truncate statement to empty a table, will it also releases the memory that was occupied by the data?

[@IshwarAcademy]

Yes, absolutely. It deallocates the data pages used to store the table data.

[@COD_MW007]

@@IshwarAcademy ohk sir, thank you

[@hiteshpatil2751]

Hii, I facing a issue in mssql. Whenever I do PRINT'rollnumber:'+@num;

[@hiteshpatil2751]

Here num is integer. But i need to print this message

[@IshwarAcademy]

For your question, follow the below solution: DECLARE @num INT = 5; PRINT 'rollnumber:' + CAST(@num as VARCHAR(10)); You have to use CAST function because you are trying to concatenate string value with integer, so integer values need to be converted in string type data. Can you share what you did?

[@hiteshpatil2751]

@@IshwarAcademy thank you for reply. can you make a video on cast funcation ?

[@hiteshpatil2751]

PRINT'hi ishwar'; declare @num int; set @num=1; while(@num

[@IshwarAcademy]

@@hiteshpatil2751 please give space after PRINT and refer my solution from the comment. i will upload video on CAST on your request.