Category: 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 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 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 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 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 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 ArticleDatediff 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 ArticleEntity 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 ArticleSql server isnull example?
In this article, I describe How to use NULLIF in sql server. As we knows nullif clause used to check …
Read ArticleHow 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 ArticleHow 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 ArticleHow 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 ArticleHow 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 ArticleHow 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 ArticleHow 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 ArticleHow 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 Article