Insert DataTable into SQL Table in C#
Description A .NET DataTable is an memory representation of an MS SQL Server table. DataTable object allows you to create …
SQL Server
Insert XML into SQL Server Table using SSMS and C#
Description In SQL Server Relational Database Management System (RDMS), we always try to create best Database Table design. So …
Read CSV File and Insert Into SQL Server using Bulk Insert
Hi, in this article, I am going to write SQL script to Import or Insert CSV file data into SQL Server …
Union vs Union ALL in SQL Server
Description In this article, I am going write the difference between Union vs Union All in SQL Server in multiple rows …
Insert Multiple Rows into Table in SQL Server
Description In this article, I am going to write T SQL Script to Insert Multiple Rows into Table in single …
Create Table in SQL Server Examples
Description In this article, I am going to write T-SQL query to Create Table in MS SQL Server in different …
Cannot drop database because it is currently in use in MS SQL Server
Description In this article, I am going to give Fix/Solution for the error ‘Cannot drop database because it is currently …
How to configure SQL Server Authentication mode SQL Server
Description In this article I am going to explain about how to enable or configure SQL Server Authentication mode or …
Import CSV File Into SQL Server Using SQL Bulk Copy
Description This article contain C# code example to import CSV file data into DataTable and insert bulk records into SQL …
The remote procedure call failed in Sql Server Configuration manager – Event ID: 1000
I have been using SQL Server 2008 R2 on my development machine for a long time. It is working well …