MSSQL

The importance of JSON data type in our lives continues to increase day by day. We will examine the functions that SQL Server provides us …

  If the domain user that you set for SQL Server Service Account does not have the following rights on the active directory, you will …

If you want to find a word in all your databases in an instance, you are in the right article. The below code block search …

  I received this error when I right-click on the database and click Properties. Property Size is not available for Database. This property may not …

You can find the last day of a month using EOMONTH function. In addition, you can use a second parameter that add a specific number …

  Computed Column is a column generated by a calculation using one or more columns in a table. For example, you have columns A, B …

You can check the expression is a valid date, time or datetime value using ISDATE Function. This function’s return type is int. Before using this …

  I will explain GETDATE, GETUTCDATE, SYSDATETIME and SYSUTCDATETIME functions in this article. GETDATE Function in SQL Server(TSQL): We can obtain current database timestamp as …

  Sometimes you cannot copy your scripts or files to the database server. If you don’t know the solution, it can be a very frustrating. …

  We can find the day using DAY function, month using MONTH function and  year using YEAR function from a date. It takes the date() …