SQL Server 2012

Format date with AM PM and without second in SQL Server 2012

Microsoft SQL Server, SQL Server 2005, SQL Server 2008, SQL Server 2012 /

 In this post, I will explain How to format date with AM PM and without second in SQL Server Format date with AM PM and without second in SQL Server Get current Hijri date in SQL Open a new query in SSMS > Drop the following query to show the data in Hijri format. SELECT CONVERT(VARCHAR(30),GETDATE(),131) AS […]

Format date with AM PM and without second in SQL Server 2012 Read More »

Saving changes is not permitted SQL Server

Errors, Microsoft SQL Server, SQL Server 2005, SQL Server 2008, SQL Server 2012, SQL Server Error /

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 »

Subscribe to Our Newsletter

Aenean massa feugiat imperdiet a scelerisque et morbi tempus massa tincidunt vitae libero aenean tincidunt molestie.

Scroll to Top