In this article, you’ll learn how to fix the SQL Server error: save changes are not permitted. This problem occurs when you try to save a table in SQL Server Management Studio (SSMS). The good news is that It is a very easy and simple setting problem that can be fixed in 5 seconds by following these steps:
Read More..In this article, you’ll learn how to get or return the server name using a query in SQL Server. There are 2 ways we are using in this post to return the server name using a query in SQL Server.
Read More..In this article, you will learn how to get or extract the week number of a year from a date in SQL Server. You can use the DATEPART() function to get the week number of a year from a date.
Read More..In this article, you will learn how to get or extract the months from a date in SQL Server(T-SQL). Here in this article, we are doing this in 3 ways to extract the month from a date. We are using the MONTH(), DATEPART(), FORMAT() functions to get or extract the month from a date in SQL Server.
Read More..In this article, you will learn how to check or find the column name which is the primary key column of a specific table in SQL Server. There are various ways to find the primary key column in SQL server.
Read More..In this article, you will learn how to drop or delete a single column or multiple columns from an existing table in SQL server. Sometimes, you need to remove a single or multiple unused or obsolete column from an existing table.
Read More..In this article, you will learn how to get or find out the identity column without using the actual column name or without knowing the actual column name.
Read More..In this article, you will learn how to add and subtract years, months, weeks, days, hours, minutes, seconds, milliseconds, microseconds, nanoseconds from DateTime in the SQL server. DateTime manipulation is the most common scenario is when we fetching data from the database or storing data in a database. Here, in this article, we will use the SQL server built-in DATEADD() function to add or subtract the days from the specific date.
Read More..In this article, we will learn how to RESEED an IDENTITY column value in SQL Server. SQL Server IDENTITY column generates sequential values for new records inserted in the table using a SEED value. This feature is very useful when you want to reset the identity column. The DBCC CHECKIDENT management command is used to reset the identity counter.
Read More..In this article, you will learn how to calculate the number of months between two specific dates in SQL Server. To get a number of months between two specific dates, we use the DATEDIFF function of SQL Server.
Read More..