sorted by: recent | see : popular

Content Tagged with SQL + faqs

How To Write an Inner Join with the WHERE Clause? - A collection of 17 FAQs on SELECT statements with joins and subqueries. Clear answers are provided with tutorial exercises on joining multiple tables with inner and outer joins; using subqueries with I...

How To Use WHILE Loops? - A collection of 5 FAQs on Transact-SQL language conditional statements and loops. Clear answers are provided with tutorial exercises on IF ... ELSE statements; WHILE loops; statement blocks; BREAK and CONTINUE statements.

What Is SQL Language? - A collection of 19 FAQs on Transact-SQL language basics and data types. Clear answers are provided with tutorial exercises on writing Transact-SQL statements; entering comments; ending and running statement batches; GO and PRINT ...

What Is Index Fragmentation? - A collection of 23 FAQs on SQL Server database indexes. Clear answers are provided with tutorial exercises on creating and dropping indexes; clustered and non-clustered indexes; indexes created by primary key and unique co...

What Is a Transact-SQL Statement? - A collection of 19 FAQs on Transact-SQL language basics and data types. Clear answers are provided with tutorial exercises on writing Transact-SQL statements; entering comments; ending and running statement batches; G...

What Is a Subquery in a SELECT Query Statement? - A collection of 17 FAQs on SELECT statements with joins and subqueries. Clear answers are provided with tutorial exercises on joining multiple tables with inner and outer joins; using subqueries with IN,...

What is a database? - A collection of 16 FAQs on creating and managing databases on SQL Server 2005. Clear answers are provided with tutorial exercises on creating, renaming, and deleting databases; setting current database; bringing databases offline a...

What Is a Boolean Value? - A collection of 14 FAQs on Transact-SQL language Boolean values and logical operations. Clear answers are provided with tutorial exercises on getting Boolean values with comparison operations; CASE expressions; BETWEEN and IN ...

What Causes Index Fragmentation? - A collection of 23 FAQs on SQL Server database indexes. Clear answers are provided with tutorial exercises on creating and dropping indexes; clustered and non-clustered indexes; indexes created by primary key and uniqu...

What Are Logical/Boolean Operations? - A collection of 14 FAQs on Transact-SQL language Boolean values and logical operations. Clear answers are provided with tutorial exercises on getting Boolean values with comparison operations; CASE expressions; BET...

What Are Comparison Operations? - A collection of 14 FAQs on Transact-SQL language Boolean values and logical operations. Clear answers are provided with tutorial exercises on getting Boolean values with comparison operations; CASE expressions; BETWEEN ...

How To Use Wildcard Characters in LIKE Operations? - A collection of 14 FAQs on Transact-SQL language Boolean values and logical operations. Clear answers are provided with tutorial exercises on getting Boolean values with comparison operations; CASE ex...

How To Use Subqueries with the IN Operators? - A collection of 17 FAQs on SELECT statements with joins and subqueries. Clear answers are provided with tutorial exercises on joining multiple tables with inner and outer joins; using subqueries with IN, EX...

How To Use Subqueries in the FROM Clause? - A collection of 17 FAQs on SELECT statements with joins and subqueries. Clear answers are provided with tutorial exercises on joining multiple tables with inner and outer joins; using subqueries with IN, EXIST...

How To Use ORDER BY with UNION Operators - A collection of 17 FAQs on SELECT statements with joins and subqueries. Clear answers are provided with tutorial exercises on joining multiple tables with inner and outer joins; using subqueries with IN, EXISTS...

How to use old values to define new values in UPDATE statements? - A collection of 18 FAQs on SQL INSERT, UPDATE and DELETE statements. Clear answers are provided with tutorial exercises on inserting, updating and deleting single and multiple rows; usin...

How To Use Group Functions in the SELECT Clause? - A collection of 20 FAQs on SQL SELECT query statements. Clear answers are provided with tutorial exercises on simple SELECT query to select specific rows and returning specific columns; applying group a...

Can Binary Strings Be Used in Arithmetical Operations? - A collection of 14 FAQs on Transact-SQL language character string and binary string operations. Clear answers are provided with tutorial exercises on concatenating character/binary strings; conver...