sorted by: recent | see :
popular
Content Tagged with SQL + dba
BCable.net - SQLIer
A SQL injection tool which you provide a URL and it does all it can to perform SQL injection.
SQL Server FAQ - Writing Inner Joins with the WHERE Clause
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...
User:Staple: SQL Server DBA FAQs and Tips - 296 Questions/Tutorials
SQL Server FAQ - Writing Character String Constants or Literals
How To Write Character String Constants or Literals? - A collection of 18 FAQs on Transact-SQL language data constants or literals and value ranges. Clear answers are provided with tutorial exercises on entering data constants or literals; quoted charac...
User:Staple: SQL Server DBA FAQs and Tips - 296 Questions/Tutorials
SQL Server FAQ - WHILE - Statement Structure for Loops
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.
User:Staple: SQL Server DBA FAQs and Tips - 296 Questions/Tutorials
SQL Server FAQ - What Is Transact-SQL Language
What Is Transact-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 a...
User:Staple: SQL Server DBA FAQs and Tips - 296 Questions/Tutorials
SQL Server FAQ - What Is SQL Language
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 ...
User:Staple: SQL Server DBA FAQs and Tips - 296 Questions/Tutorials
SQL Server FAQ - What Is Microsoft SQL Server
What is Microsoft SQL Server? - A collection of 14 FAQs on SQL Server 2005 Express Edition download and installation. Clear answers are provided with tutorial exercises on installing SQL Server 2005 Express Edition; installing .NET Framework Version 2.0...
User:Staple: SQL Server DBA FAQs and Tips - 296 Questions/Tutorials
SQL Server FAQ - What Is Index Fragmentation
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...
User:Staple: SQL Server DBA FAQs and Tips - 296 Questions/Tutorials
SQL Server FAQ - What Is a Transact-SQL Statement Batch
What Is a Transact-SQL Statement Batch? - 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 batc...
User:Staple: SQL Server DBA FAQs and Tips - 296 Questions/Tutorials
SQL Server FAQ - What Is a Transact-SQL Statement
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...
User:Staple: SQL Server DBA FAQs and Tips - 296 Questions/Tutorials
SQL Server FAQ - What Is a Table
What is a table? - A collection of 16 FAQs on creating and managing tables on SQL Server 2005. Clear answers are provided with tutorial exercises on creating, renaming, and deleting tables; reviewing, renaming, deleting and adding table columns; changin...
User:Staple: SQL Server DBA FAQs and Tips - 296 Questions/Tutorials
SQL Server FAQ - What Is a Subquery in a SELECT Query Statement
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,...
User:Staple: SQL Server DBA FAQs and Tips - 296 Questions/Tutorials
SQL Server FAQ - What Is a SELECT Query Statement
What Is a SELECT Query Statement? - 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 aggregation func...
User:Staple: SQL Server DBA FAQs and Tips - 296 Questions/Tutorials
SQL Server FAQ - What Is a Database
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...
User:Staple: SQL Server DBA FAQs and Tips - 296 Questions/Tutorials
SQL Server FAQ - What Is a Constant or Literal
What Is a Constant or Literal? - A collection of 18 FAQs on Transact-SQL language data constants or literals and value ranges. Clear answers are provided with tutorial exercises on entering data constants or literals; quoted character strings; date and ...
User:Staple: SQL Server DBA FAQs and Tips - 296 Questions/Tutorials
SQL Server FAQ - What Is a Boolean Value
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 ...
User:Staple: SQL Server DBA FAQs and Tips - 296 Questions/Tutorials
SQL Server FAQ - What Is an Expression
What Is an Expression? - A collection of 14 FAQs on Transact-SQL language numeric expressions and functions. Clear answers are provided with tutorial exercises on writing numeric expressions; arithmetic operations; implicit data type conversions; explic...
User:Staple: SQL Server DBA FAQs and Tips - 296 Questions/Tutorials
SQL Server FAQ - What Causes Index Fragmentation
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...
User:Staple: SQL Server DBA FAQs and Tips - 296 Questions/Tutorials
SQL Server FAQ - What Are Views
What Are Views? - A collection of 21 FAQs on SQL Server database views. Clear answers are provided with tutorial exercises on creating and dropping views; defining and viewing view columns; creating views from multiple tables; inserting, updating and de...
User:Staple: SQL Server DBA FAQs and Tips - 296 Questions/Tutorials
SQL Server FAQ - What Are Logical/Boolean Operations
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...
User:Staple: SQL Server DBA FAQs and Tips - 296 Questions/Tutorials
SQL Server FAQ - What Are Indexes
What Are Indexes? - 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 constraints; ...
User:Staple: SQL Server DBA FAQs and Tips - 296 Questions/Tutorials
SQL Server FAQ - What Are Comparison Operations
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 ...
User:Staple: SQL Server DBA FAQs and Tips - 296 Questions/Tutorials
SQL Server FAQ - Verifying SQL Server Running Status
How do you know if SQL Server is running on your local system? - A collection of 14 FAQs on SQL Server 2005 Express Edition download and installation. Clear answers are provided with tutorial exercises on installing SQL Server 2005 Express Edition; inst...
User:Staple: SQL Server DBA FAQs and Tips - 296 Questions/Tutorials
SQL Server FAQ - Using Wildcard Characters in LIKE Operations
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...
User:Staple: SQL Server DBA FAQs and Tips - 296 Questions/Tutorials
SQL Server FAQ - Using Values from Other Tables in UPDATE Statements
How To Use Values from Other Tables 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; using colum...
User:Staple: SQL Server DBA FAQs and Tips - 296 Questions/Tutorials
SQL Server FAQ - Using Subqueries with the IN Operators
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...
User:Staple: SQL Server DBA FAQs and Tips - 296 Questions/Tutorials
Page 1 | Next >>