Replace string as camelCase in MSSQL

Convert your words from snake_case to camelCase replacing "_" using CTE table.

PIVOT IN MSSQL

Pivot in mssql with very simple example

Find Quarter Dates and month start and end dates

Find Quarter Dates and month start and end dates

Generate Series IN SQL

Generate Series in SQL

Convert Date DDMMYY to DateTime

Convert Date DDMMYY to DateTime

Allow special char in Oracle

Allow special char "&" in Oracle

Get Hour and minute in SQL

Get Hour and minute in SQL

See what queries are currently running

Sometimes you required to see what is currently running on a SQL server. Its usually required when any query is running from very long time and you need to tran what query is running On SQL Server 2005 and later this is easy to achieve using View dm_exec_requests (Dynamic Management).

What is SQL?

SQL stands for Structured Query Language. It is the standard language for dealing with relational database.