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 …
Read More »MSSQL
Property Size is not available for Database. This property may not exist for this object, or may not be retrievable due to insufficent access rights.
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 …
Read More »EOMONTH Function in SQL Server(TSQL)
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 …
Read More »Computed Column in SQL Server
Computed Column is a column generated by a calculation using one or more columns in a table. For example, you have columns A, B …
Read More »ISDATE Function in SQL Server(TSQL)
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 …
Read More »GETDATE, GETUTCDATE, SYSDATETIME and SYSUTCDATETIME Functions in SQL Server(TSQL)
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 …
Read More »Can not Copy and Paste to Remote Desktop
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. …
Read More »DAY, MONTH and YEAR Functions in SQL Server(TSQL)
We can find the day using DAY function, month using MONTH function and year using YEAR function from a date. It takes the date() …
Read More »What is SQL Server Synonym and How To Use It
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 …
Read More »How To Convert Gregorian Date to Hijri Date or Hijri Date to Gregorian 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 …
Read More »