SQL Server

RSS Subscribe

Using a Format File to Bulk Import Data in SQL Server

Posted on February 5, 2019 by Suresh Kamrushi in SQL Server

+10 SQL Server OPENROWSET (starting with 2008) supports bulk operations through a built-in BULK provider that enables data from a file to be read and …

Generating and Formatting excelsheet in c# using EPPlus

Posted on August 13, 2018 by Suresh Kamrushi in C#, SQL Server

+50 Getting data from database in DataTable format and then generating Excel sheet and formatting it using EPPlus is very easy in C# MVC. Here …

Creating new Database User in SQL Server using Management Studio

Posted on February 26, 2018 by Suresh Kamrushi in SQL Server

+30 Follow below steps to create a database user using SQL Server Management Studio. 1) Open SQL Server Management Studio and open “Object Explorer” and …