GitHub

kansiris/SQL-interview-questions

1 What is an inner join in SQL? 1 What is an outer join in SQL? 1 What is full join in SQL? 1 What is left join in SQL Server? 1 What is a right join in SQL Server? 1 What is database engine in SQL ...
Hacker

SQL vs T-SQL: Key Differences and Use Cases

A Technical Project Manager with expertise in agile methodologies, project planning, quality assurance, and more. SQL (Structured Query Language) is the universal language for managing and interacting ...
GitHub

Simple DB Load Generator

Purpose of this application is to enable users to generate or simulate some work load on a database. SimpleDBLoadGenerator uses a predefined set of SQL statements which can be executed in a single or ...
TechRepublic

Using recursion in stored procedures

The basic concept of recursion is straightforward: a given chunk of code calls itself until some boundary condition is reached. Arthur Fuller demonstrates how to use recursion in T-SQL. TechRepublic’s ...