Latest posts on tagged on "SQL"

In this tutorial I will show you how to export data from remote server (godaddy live server) to local database. First of all create a database name in local server (any name) called “godaddyBackup”.

In this tutorial tutorial I will demonstrate you how to generate SQL Query Script for both schema and data using SQL Server management Studio 2012.

Initially I want to apply the foreign key for Student table .But the error occurred. Because of variation in data type. I got the following error “The following data type properties of the column do not match those of Data type, length, precision”

In this article I will show you how to change password code in c# asp.net. For change password, first the user needs to register the details. When the registered user wants to change the password, he/she has to login into the account with username and password.

In this article I will show you how to create asp.net c# login page code with sql database. In this login form multiple user can login with the form, If the username and password matches with the database it allows user to login.

In this article, I will show you jQuery dropdownchecklist example using SQL server in asp.net mvc. Use JQuery multiselect bootstrap plugin along with bootsrap css, so that you...

I am using dapper, I got the following error message “Procedure or function has too many arguments specified” while inserting data into database.

In this article, I will show you how to insert, update, delete in asp.net mvc using stored procedure in asp.net mvc dapper.

In this article, I will show you how to insert data and get a return value Reference ID from stored procedure in c# asp.net mvc dapper. The reference Id will be generated from database and it is the combination of the first four letters of the ItemName and Itemid.

In this article, I will show you how to implement custom paging in SQL servre 2008. I used ROW_NUMBER() in where clause to achieve ms sql paging.