MSSQL

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() …

Synonym is to give alias (an alternative name) to some objects on a database basis. The synonym can be created for following objects. Table View …

A friend ask to me to conversion about gregorian date to hijri date or hijri date to gregorian date. I will explan this conversions in …