The following T-SQL statement shows how output the name of a day from a date. For example, 16 March 2019 would output Saturday. SELECT DateName( weekday , GETDATE() ) as…
The following T-SQL statement shows how output the day from a date. For example, 16 March 2019 would output 16. SELECT DateName( day, GETDATE() ) as Day_From_Date
The following T-SQL shows how to update a value using the results of a SELECT query. This applies to Microsoft SQL server (T-SQL) -- and will not work in MySQL.…
The following steps detail how to create a read-only user for an SQL database using Microsoft SQL Server Management Studio. This may be helpful if you need to give access…
The client logs are located in the %WINDIR%\System32\CCM\Logs folder or %WINDIR%\SysWOW64\CCM\Logs (for x64 OS). The SCCM server log files are located in the <INSTALL_PATH>\Logs or SMS_CCM\Logs folder. IIS logs can…