Tag: SQL

Apr 24, 2023

Saving changes is not permitted in SQL SERVER - [SOLVED]

I want to add new Column to table. But while saving, It showing this warning message and not allowed to …

Read More →

Apr 19, 2023

Restore of database failed. File cannot be restored over the existing. -[SOLVED]

When I was tried to restore the database but the restore of database is failed and showing the following error …

Read More →

Feb 14, 2023

This action cannot be completed because the file is open in SQL Server(SQLEXPRESS) - FIXED

I got this following error when I tried to copy the database .mdf and .ldf files to another location.

Read More →

May 23, 2022

Restore of database 'DATABASE' failed. (Microsoft.SqlServer.Management.RelationalEngineTasks)

When I tried to restore the SQL database it was failed and got the error message. " The backup set …

Read More →

Oct 06, 2021

Access denied sql server attach database

When I tried to attach the SQL database to the local server I got this following error "access is denied".

Read More →

Oct 06, 2021

How to attach database in sql server using cmd?

In SQL Server we can use the SQL command to attach database to Microsoft Sql Server. Just copy the mdf …

Read More →

Aug 29, 2018

Sql corresponds to the Asp.Net data type

During the development of the program, when creating SQL stored procedure parameters, you need to find the corresponding SQL data …

Read More →

Jan 17, 2018

Website Construction Guide

What should a website developer have to master? HTML and CSS, Client-side script - JavaScript and the DOM Server-side script …

Read More →

Jan 17, 2018

Website database

MS SQL Server or Oracle for high traffic database driven website. MySQL for low-cost database access. MS Access for low …

Read More →

Oct 07, 2017

Export SQL query results to Excel?

In this video tutorial I will show how to export SQL Query results to excel using Microsoft SQL Server. After …

Read More →

Oct 07, 2017

How to export data from Remote server to local server using SQL server?

In this tutorial I will show you how to export data from remote server (godaddy live server) to local database. …

Read More →

Sep 25, 2017

How to Generate Script for both schema and data using SQL server management Studio 2012

In this tutorial tutorial I will demonstrate you how to generate SQL Query Script for both schema and data using …

Read More →

Apr 21, 2017

The following data type properties of column do not match those of Data type, length, precision.

Initially I want to apply the foreign key for Student table .But the error occurred. Because of variation in data …

Read More →

Jan 09, 2017

How to change password in asp.net using c#?

In this article I will show you how to change password code in c# asp.net. For change password, first the …

Read More →

Jan 09, 2017

How to create login page in asp.net?

In this article I will show you how to create asp.net c# login page code with sql database. In this …

Read More →

Jan 03, 2017

How to add checkbox in dropdownlist using jQuery?

In this article, I will show you jQuery dropdownchecklist example using SQL server in asp.net mvc. Use JQuery multiselect bootstrap …

Read More →

Dec 09, 2016

Procedure or function has too many arguments specified-dapper c#

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

Read More →

Dec 09, 2016

CURD operations in asp.net mvc using dapper example c#

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

Read More →

Dec 08, 2016

How to insert data using stored procedure in asp.net mvc dapper example?

In this article, I will show you how to insert data and get a return value Reference ID from stored …

Read More →

Nov 28, 2016

Custom Paging SQL Server example

In this article, I will show you how to implement custom paging in SQL servre 2008. I used ROW_NUMBER() in …

Read More →

Oct 19, 2016

How to get size of all tables in database using SQL Query?

In this article, I will show you how much space used/unused by the all tables in SQL server database using …

Read More →

Oct 17, 2016

How to create password encryption and decryption in c# asp.net (entity framework)?

In this article, I will show you how to create password encryption and decryption in c# asp.net. I am going …

Read More →

Oct 06, 2016

How to use like Operator in Sql Stored procedure?

In this article I will show you how to create Sql Server Stored procedure like, parameter implemented for it. Here …

Read More →

Sep 22, 2016

How to find SQL server database version and SQL server Editon?

You can identify the SQL server database version and SQL server Editon of installed product in PC/server by using the …

Read More →