Tag: SQL
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 ArticleRestore 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 ArticleThis 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 ArticleRestore 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 ArticleAccess 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 ArticleHow 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 ArticleSql 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 ArticleWebsite Construction Guide
What should a website developer have to master? HTML and CSS, Client-side script - JavaScript and the DOM Server-side script …
Read ArticleWebsite database
MS SQL Server or Oracle for high traffic database driven website. MySQL for low-cost database access. MS Access for low …
Read ArticleExport 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 ArticleHow 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 ArticleHow 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 ArticleThe 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 ArticleHow 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 ArticleHow 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 ArticleHow 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 ArticleProcedure 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 ArticleCURD 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 ArticleHow 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 ArticleCustom 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 ArticleHow 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 ArticleHow 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 ArticleHow 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 ArticleHow 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 Article