Tag Archives: Example

ILT – How To Change SQL Server Default Database?

16-10-2012 I have been annoyed by having to change the database from the available databases drop-down whenever I want to write a query. This was because the default database which is always selected was the “Master” database which I never use.             If you had the same problem then thisContinue reading “ILT – How To Change SQL Server Default Database?”

Oracle Trunc Function

2008-11-24 Among various helpful functions provided by Oracle, Trunc function took my attention today because I had to fix a defect where some one has misunderstood and misused this function. As the name itself suggests, the trunc function is capable of truncating a value. This function can be used either on a date type valueContinue reading “Oracle Trunc Function”