In this post , We will learn how to import excel data to SQL using C# with the help of OLEDB . This is a time saver especially if you wan to add tons and tons of data to your table within a fraction of second a so let’s get started.
In this article, we will learn how to use the most important SSMS (SQL Server Management Studio) keyboard shortcuts.
In computing, a keyboard shortcut is a series of one or several keys that invoke a software program to perform a pre-programmed action.
In this article, we will learn how to use the Table-Valued Function in SQL. A Table-Valued Function returns a single rowset.
In this article, we will learn how to use a Stored Procedure in SQL.
The SQL query can be saved as a stored procedure, and then just call it to execute it. So the code can be used over and over again.
In this article, we will learn how to find and remove duplicate records in SQL.
In this article, we will learn about how to get the Connection String from SQL Server using Visual Studio.
In this article, we will learn how to create a user in SQL.
To create a user for a database, we first have to create a new login for the server or we can use an existing one.
In this article, we will learn how to create a login in SQL.
In this article, we will learn how we can generate script(s) of our database with existing data, in SQL Server.
Once database script(s) are generated, the result will give you an insert query with other queries so that the data also will get inserted in your new database.
In this article, we will learn how to export data from SQL to excel file.
