Posts Tagged ‘databases’
September 14, 2009 - 9:12 pm
From chapter 3.2 of T-SQL 2008 Joes 2 Pros (www.joes2pros.com). Learn how to find matches and exceptions with outer joins.
Duration : 0:4:54
(more…)
Tags: 2005, 2008, beginner, clause, code, columns, criteria, data, databases, easy, entity, fields, Full, information, inner, introduction, Joes, Joins., learn, left, lessons, lingo, Outer, queries, query, records, Right, Rows, select, Server, simple, sql, statement, t-sql, table, terms, training, tutorial Posted in sql statement |
September 9, 2009 - 1:30 am
From chapter 2.2 of T-SQL 2008 Joes 2 Pros (www.joes2pros.com). How to use range and pattern matches in a basic single table query in SQL server 2005 and 2008. Full Video is a free download at www.Joes2Pros.com along with a PDF book sample.
Duration : 0:8:58
(more…)
Tags: 2005, 2008, beginner, clause, code, criteria, data, databases, demonstration, easy, how-to, information, introduction, Joes, learn, lessons, Like, operators, queries, query, records, select, Server, simple, sql, statement, t-sql, table, training, tutorial, Wildcards Posted in sql statement |
August 25, 2009 - 11:17 am
From chapter 1 of T-SQL 2008 Joes 2 Pros (www.joes2pros.com). Learn the basic terms or Geek Speak used by SQL Server database professionals.
Duration : 0:4:46
(more…)
Tags: 2005, 2008, beginner, clause, code, columns, criteria, data, databases, easy, entity, fields, information, introduction, Joes, learn, lessons, lingo, queries, query, records, Rows, select, Server, simple, sql, statement, t-sql, table, terms, training, tutorial Posted in sql statement |
August 16, 2009 - 4:18 am
www.Joes2Pros.com How to use exact criteria matches in a basic single table query in SQL server 2005 and 2008.
Duration : 0:7:59
(more…)
Tags: 2005, 2008, beginner, Beginners, clause, code, criteria, data, databases, demonstration, easy, how-to, information, introduction, Joes, learn, lessons, queries, query, records, select, Server, simple, sql, statement, t-sql, table, training, tutorial Posted in sql statement |
August 6, 2009 - 11:14 pm
www.Joes2Pros.com… Learn how to use basic inner joins to see two tables in one results set..
Duration : 0:8:37
(more…)
Tags: 2005, 2008, beginner, clause, code, columns, criteria, data, databases, easy, entity, fields, information, inner, introduction, Joes, Joins., learn, lessons, lingo, queries, query, records, Rows, select, Server, simple, sql, statement, t-sql, table, terms, training, tutorial Posted in join statement |
Common data scenarios require developers to write and maintain logic to determine whether to insert, update or delete information (sometimes called upsert) such as:
IF FOUND
THEN UPDATE
ELSE
INSERT
SQL Server 2008 provides the new MERGE statement within the SQL language to enable developers to provide this functionality with a single statement. This allows for code reduction and easier maintainability.
Duration : 0:3:28
(more…)
Tags: (TSQL), 2008, database, databases, magenic, merge, Server, sql, t-sql Posted in delete statement |
Use code to create an if-then statement in Excel VBA by using corresponding worksheet cells. Use an if-then statement in Excel VBA with tips from a software developer in this free video on using Microsoft Excel.
Expert: Dave Andrews
Contact: www.daveandrews.org
Bio: Dave Andrews is a software developer that holds a degree in computer science. Currently, he is employed by a government IT department.
Filmmaker: Tim Brown
Duration : 0:2:52
(more…)
Tags: computer, databases, email, excel, FTP, HTML, Internet, Microsoft, MYSQL, online, programs, sites, software, sql, Web Posted in sql statement |
A delete action query in Microsoft Access is based upon the delete statement of SQL, and it can be created by clicking on the “Create” tab and the group “Query Design.” Change a query type from a select statement to a delete statement with help from a computer programming teacher in this free video on Microsoft Access.
Duration : 0:3:34
(more…)
Tags: Access, application, database, databases, development, graphical, interfaces, management, Microsoft, Office, relational, software, system, tutorial, user Posted in delete statement |