While writing queries in stored procedures we manipulate with the string data type columns in which concatenating string is very common.so we all are very familiar with the function concat provided by ...

Part 1 of this article introduced four new T-SQL functions available in SQL Server 2012. Part 2 has the rest.

DESCRIPTION SQL::Concat is NOT a SQL generator, but a minimalistic SQL fragments concatenator with safe bind-variable handling. SQL::Concat doesn't care anything about SQL syntax but placeholder and ...

Many people are confused by various JOIN operations supported by SQL. Learn to master the SQL command line with this crash course in JOIN syntax.