Prabakar Murali

Blogs from this Author

Generate Scripts for Data in the Tables of SQL SERVER

This wizard is helpful for generating scripts and publishing them. In order to run the wizard, right click on the database and navigate to Tasks -> Generate Scripts. The wizard will pop up and you can generate scripts either for all database objects or for a selected number of database objects. This could be used […]

How to Import Data from Excel in Microsoft SQL SERVER

There may be cases where the data source can be in a¬†specific¬†format to insert into the database. If an enormous amount of data is present in other sources such as a flat file or excel, SQL Server allows the user to import data from it using the Import Data Wizard. Here’s how: Right click on […]