In this article, we will learn How to create a dynamic pivot without aggregate function in SQL Server? You might also like to read Convert Rows To Columns Using Dynamic Pivot In SQL Server Dynamic pivot without aggregate function in SQL Server I have the below three tables (One-Many relations) The 1st table (Table) holds […]
Dynamic pivot without aggregate function in SQL Server Read More »
In SQL Server 2012, I got “Saving changes is not permitted” The changes you have made require the following tables to be dropped and re-created. You have either made changes to a table that can’t be re-created or enabled the option Prevent saving changes that require the table to be re-created when I tried to change
Saving changes is not permitted SQL Server Read More »
In this post, we’ll learn how to fix “The database could not be exclusively locked to perform the operation” error that you may encounter when renaming a database in SQL Server. You might also like to read Database is not accessible due to a Single User mode The database could not be exclusively locked to
Rename SQL Server database: The database could not be exclusively locked Read More »
