MSSQL

  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 …

  We can get a date by combining the values such as year, month and day with the help of DATEFROMPARTS, DATETIMEFROMPARTS, DATETIME2FROMPARTS, SMALLDATETIMEFROMPARTS functions. …

  When a database owner changes his password, you may receive errors as follows. Therefore, it would make more sense to set the owner of …

  ColumnStore Index entered our lives with SQL Server 2012.  Normally the index is stored in the disk as row-based, and the index is created …