TSQL

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 …

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 …

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 …

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

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. …

  We can find the difference between the two dates using the following dateparts with the DATEDIFF function. The return data type is int. If …

  With the DATEADD function we can add or remove a datepart to a date. Below is a list of the dateparts we can add. …

  We can set the first day of the week for a session with SET DATEFIRST Statement. We can query the first day of the …