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 24, 2023
Category: SQL
Browse articles in this category.
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
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 →
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 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 →
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 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 →
Sep 05, 2016
Datediff Sql Compare two dates
In this article, I will explain how to compare two dates and gets number of days using Datediff in SQL …
Read More →
Aug 29, 2016
Entity framework connection string example
To get the SQL connection string from entity framework using DbConetext edmx file. In this example I will show you …
Read More →
Jul 08, 2016
Sql server isnull example?
In this article, I describe How to use NULLIF in sql server. As we knows nullif clause used to check …
Read More →
Jul 08, 2016
How to modify or insert already existing table value using by another table in sql server?
In this article, I describe How to modify or insert into already existing table value using by another table.This is …
Read More →
Jul 08, 2016
How to copy/insert a table value from one table to another in sql server?
In this article, I describe How to copy or insert one table value to another table.This is achieved by a …
Read More →
May 07, 2016
How to create while loop SQL server?
In this article we will discuss, How to create while loop SQL server We will be using Employee table. Below …
Read More →
Mar 23, 2016
How to find your Current bank balance using SQL query?
In this section, I explain how to find your bank balance using sql query. This questions asked by many interviewer, …
Read More →
Mar 21, 2016
How to append prefix to existing value in a field using sql query?
In this article, I describe how to append prefix to all existing value in a field using sql query. Here …
Read More →
Mar 21, 2016
How to get first, last date and total days in a month from current date using sql query?
In this article, I found a sql query to find first, last and total days in a month from the …
Read More →
Mar 21, 2016
How to get DAY , MONTH and YEAR from current date using sql query?
In this article, I found a sql query to find day, month and year from the current or any date …
Read More →
Page 1 of 2
Next »