In a situation where Servers are linked, it is possible to retrieve data from a table in one server to a table on the other
SQL Server – Self Joins
To join tables, at-least two tables are required. This does not indicate two different tables. It is possible to join a table with itself to
SQL Server – Date Time Functions
Here are a few examples of functions that can help you manipulate DATE in different manners. These will comprise most of your daily job routines.
SQL Server – CHARINDEX – Oracle INSTR
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
SQL Server – List Out Number of Rows from all tables
To Find-Out Number Of Rows In Each Table In Database. METHOD-1 DECLARE @TotalRows INT, @FirstID INT, @table VARCHAR(255), @cmd VARCHAR(500) CREATE TABLE #tableData (TableName VARCHAR(255),
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
Big Data and SQL 