Prepare Interview

Mock Exams

Make Homepage

Bookmark this page

Subscribe Email Address

DBMS%20Interview%20Questions%20and%20Answers

Question: Can you explain the SELECT INTO Statement?
Answer:
SELECT INTO statement is used mostly to create backups. The below SQL backsup the
Employee table in to the EmployeeBackUp table. One point to be noted is that the structure of
wbEmployeeBackup and wbEmployee table should be same. SELECT * INTO
wbEmployeeBackup FROM wbEmployee
Is it helpful? Yes No

Most helpful rated by users:

©2024 WithoutBook