Friday, December 8, 2017

How to backup table or copy table in sql server

How to backup table or copy table in sql server

Copy or Backup All Column
SELECT * INTO  EMPLOYEE_BACKUP FROM EMPLOYEE

Copy or Backup Selectd Column
 
SELECT EMP_NAME,EMP_SALARY INTO EMPLOYEE_SELECTDBACKUP  FROM EMPLOYEE

4 comments: