Comments by HichSkill (Top 9 by date)

For your example, is it possible to put the ID by another local variable? For example
INSERT INTO Product_2 ('1', Label, ID_Cat)
SELECT ID, Label, ID_Cat
FROM Product
WHERE ID_Cat = @CategoryID;

I tried this method, but the problem is that they are not the same ID and it is not auto.

Thank you for your answer.
My problem is that I want to copy the details and information from one table to another. For example, transfer a quote to a purchase order in the sales management, do you have an example to modify my code? I am an apprentice in programming. Thank you in advance.

I saw this method in commercial management software which hides the price excluding VAT column so as not to disturb it