Posts Tagged ‘query’
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 31, 2009 - 6:16 am
I declare Code Sin #1: poorly formatted code. Look, the video’s uner 90 seconds long…watch it. Your successors, your coworkers — your CHILDREN, will thank you.
Duration : 0:1:26
(more…)
Tags: (TSQL), by, code, coding, cool new features, formatting, free, free training, free training videos, free videos, from, group, having, help, IT videos, Jen McCown, Jennifer McCown, katmai, Microsoft tutorial, Midnight DBA, MidnightDBA, order, parse, query, Sean McCown, select, sql, sql server, SQL Server 2008, SQL Server MVP, SSMS, statement, t-sql, Tips, tips and tricks, where, Windows 7 Posted in select 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 22, 2009 - 5:14 am
How does SQL see a SELECT statement? Which part gets evaluated first? Why should I care? Find out here, find out fast!
1 - From
2 - Where
3 - Group by
4 - Having
5 - Select
6 - Order by
Duration : 0:2:5
(more…)
Tags: (TSQL), by, cool new features, free, free training, free training videos, free videos, from, group, having, help, insert, insert into, IT videos, Jen McCown, Jennifer McCown, katmai, Microsoft tutorial, Midnight DBA, MidnightDBA, order, parse, query, Sean McCown, select, select into, sql, sql server, SQL Server 2008, SQL Server help, SQL Server MVP, SSMS, statement, t-sql, Tips, tips and tricks, where, Windows 7 Posted in select 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 |