Why m i getting error incorrect syntax near the keyword IN in the following query?
select * into persons_backup IN 'HRMS.mdb' from persons
Thank you
Add a comment
|
2 Answers
Assuming SQL Server (based on your previous question) you would need
select *
into persons_backup
from HRMS.mdb.persons
or
select *
into HRMS.mdb.persons_backup
from persons
dependant upon what you are trying to do exactly. See SELECT ... INTO syntax here
10 Comments
vatspoo
I tried ur second option but it says "The specified schema name "mdb" either does not exist or you do not have permission to use it." Please clarify how can i get rid of that. Secondly, whats wrong with my query(specified in the ques)? The syntac i hav used is the one specied in w3schools.
Martin Smith
I had to guess what you are trying to do as your question just provides invalid syntax with no explanatory text.
HRMS.mdb.persons is ih the format databasename.schemaname.tablename If you don't have a schema called mdb then what are you trying to do exactly? To SELECT ... INTO a table in your default schema just use select * into persons_backup from personsvatspoo
i want to create backup of persons table in another database called "HRMS". This database already exists.
Martin Smith
This is another SQL Server Datbase? If so why does your query have
.mdb If there is no such schema? You need to create this schema or use a different existing one. e.g. select * into HRMS.dbo.persons_backup from personsMartin Smith
@vatspoo - Ah right looks like the syntax you were trying to use is for Microsoft Access not SQL Server
|
Assuming you want to add all rows from persons into another table persons_backup:
Insert into persons_backup select * from persons;
Depending on the RDBMS you use, you might have to put () around the select.
1 Comment
vatspoo
For using this query i will hav to create the "persons_backup" table first. I am trying to use select into for creating backup.