There is a ‘CharIndex’ function in SQL Server which is similar to the Oracle ‘Instr’ function. In Oracle, the syntax of the INSTR function is
Category: SQL Server Functions
SQL Server – Monthly Report – Group by Month
The following example guide you to retrieve a monthly report. As discussed earlier, If the date column is SMALLDATETIME or DATETIME, we can split it
SQL Server – Daily Report – Group by Date
Like hourly report, the following example guide you to retrieve a daily report. As discussed earlier, If the date column is SMALLDATETIME or DATETIME, we
SQL Server – Hourly Report – Group by Hour
Often it is important to know how many inserts occur per hour in a transaction table OR how many payments are made per hour OR
SQL Server – GETDATE(), CURRENT_TIMESTAMP in DEFAULT statements
Most of the transactional tables generally do require to have a column with DEFAULT value as current date time to identify when the transaction had
SQL Server – CASE Function- Examples
This article talks about an equivalent of Oracle SQL’s DECODE function in SQL Server. There is no such function in SQL Server but through CASE
Big Data & SQL 