SQL – Concatenate

Background Across the various database systems, data Concatenation used to be everyman for himself. As in Oracle uses "|" as in:-   Transact SQL uses "+" as in:- DBA Pity the DBA he gets a query and he has to make changes to fit his\her platform. If it is a new code, he will appreciate … Continue reading SQL – Concatenate

SQL and Bible Studies:- Books in each Genre

Background The Bible is a collection of books. One can categorize the books in so many different ways. In this post, we will use someone else work. He has categorized bible books into genres.   SQL The work avails a couple of database platforms. In this post, we will provide working samples for Transact SQL … Continue reading SQL and Bible Studies:- Books in each Genre