These are some of the Very Important Questions that you come across in your Sqlserver programming life. sqlserver interview questions and answers:

1.How to backup a single table with its data from database in sql server?

Answer:
1.RIGHT CLICK DATABASE 2.SELECT TASKS=>GENERATE SCRIPTS 3.CHOOSE TABLE OR OBJECTS 4.SET SCRIPTING OPTIONS AND CLICK ADVANCED 5.SELECT TYPES OF DATA TO SCRIPT AND CHOOSE SCHEMA AND DATA 6.CLICK NEXT AND FINISH