Posts Tagged ‘t-sql’
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 12, 2009 - 12:16 am
Adam Machanic interviews Joe Celko at the 2006 PASS Summit where Joe recalls an old trick that was used before the CASE statement was added to the SQL language.
Duration : 0:0:48
(more…)
Tags: Adam Machanic, boyce, database, Itzik, Joe Celko, kalen, Microsoft, PASS Summit, solid quality, sql server, t-sql, TechEd 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 |
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 |