SELECT * INTO NewTable FROM existingdb.dbo.existingtable;
I am executing this query but it is showing me the error as undeclared variable:Quanti
(as quanti is my NewTable)
Not enough information to go on. What is the exact statement you are executing? What is the exact error message you are receiving? Where are you executing the statement (e.g. SSMS, or from a program, or some other tool)? What is the data structure of the old table? Are you trying to create the new table in the same database?
Can't help if it's too vague.
U may want to check your syntax well.
Please ignore the 'R', i was on my mobile so i did not notice those errors
Here's the correct syntax:
SELECT select_list INTO [New_Table_Name] FROM Table_List
We're a friendly, industry-focused community of 1.18 million developers, IT pros, digital marketers, and technology enthusiasts learning and sharing knowledge.