In the following article we will go through a solution to a very common requirement of getting Nth record in a SQL server table. Let us first create a table and add sample data to this table. Col1 in ...

Hello all, The below tutorial will help you in displaying SQL row data as a column wise with user specific column name. here, I've a table with #Temp1 name that contains the following columns Id, ...

SQL Bulk Insert has been tuned over the years to work well with the Microsoft .NET Framework. This tutorial shows you how to take advantage of its power. SQL Bulk Insert is not a new technology. In ...

After creating a MySQL database and table, we can start inserting the data (i.e. records) in them. In this tutorial, we are going to learn how to insert data in MySQL database using PHP in XAMPP stack ...