There is a ‘ CharIndex’ function in SQL Server which is similar to the Oracle ‘ Instr’ function. In Oracle, the syntax of the INSTR functi...

Here is the link for Microsoft SQL Server Community Projects & Samples. They have provided the best examples and databases in the follow...

To List-Out The Number Of Rows In Each Table From The Current Database. To Find-Out Number Of Rows In Each Table In Database. /**********...

The following example guide you to retrieve a monthly report. As discussed earlier, If the date column is SMALLDATETIME or DATETIME, we can ...

Like hourly report, the following example guide you to retrieve a daily report. As discussed earlier, If the date column is SMALLDATETIME or...

Sometimes it requires to know how many inserts are happend every hour in a transactions table OR how many payments made every hour OR to ret...

INSERT can be used in different ways. The following examples will guide you the method of row constructions using INSERT. CREATE TABLE Test...

To establish a connection between two or more tables, foreign key constraint will be used. One table's primary key column can be referre...

Most of the transactional tables generally do require to have a column with DEFAULT value as current date time to identify when the transact...

I heard many people asking about alternative for Oracle DECODE in SQL Server. There is no such function in SQL Server but through CASE funct...