SQLServerCentral: Content tagged T-SQL, SQL Server 2008

Number of Rows

By Dave 2013/01/18 | Category: t-sql

Rating: (not yet rated) |

Discuss |

Briefcase | 2,232 reads

Understanding and Using APPLY (Part 2)

The second of a series by Paul White examining the APPLY operator. In this section learn how this operator compares with joins and about both the cross and outer options. Read more...

By Paul White 2012/01/13 (first published: 2010/04/19) | Source: SQLServerCentral.com | Category: apply

Rating:

|

Discuss |

Briefcase | 19,202 reads

Understanding and Using APPLY (Part 1)

The first of a two-part series of articles examining the APPLY operator. Learn the basics of how this operator works and how it can help you solve some tricky problems. Read more...

By Paul White 2012/01/06 (first published: 2010/04/12) | Source: SQLServerCentral.com | Category: apply

Rating:

|

Discuss |

Briefcase | 32,487 reads

Using TOP To Rank Columns In a Table

This article covers the use of the TOP clause to select data from a table based on the TOP n columns in a table. Read more...

By Tim Parker 2011/10/25 | Source: SQLServerCentral.com | Category: sql server 2005

Rating:

|

Discuss |

Briefcase | 6,278 reads

Table Value Constructors in SQL Server 2008

Table Value Constructors (TVCs) are a useful feature of 2008, allowing you to specify tables of values and expressions. Users who are stuck with previous versions of SQL Server can play along, since Rob Sheldon demonstrates that there have always been ways of doing this in SQL Server, though less elegantly. Read more...

By Additional Articles 2011/07/07 | Source: SimpleTalk | Category: sql server 2008

Rating: (not yet rated) Rate this |

Briefcase | 3,116 reads

OUTPUT & NEWID()

By Jason Selburg 2011/04/25 | Category: t-sql

Rating: (not yet rated) |

Discuss |

Briefcase | 2,954 reads

ANSI Padding

By Tom Thomson 2011/01/11 | Category: sql server 2008

Rating: (not yet rated) |

Discuss |

Briefcase | 2,673 reads

What's the best way to count?

By Dave 2010/10/19 | Category: t-sql

Rating: (not yet rated) |

Discuss |

Briefcase | 4,126 reads

The MERGE Statement in SQL Server 2008

When the SQL MERGE statement was introduced in SQL Server 2008, it allowed database programmers to replace reams of messy code with something quick, simple and maintainable. The MERGE syntax just takes a bit of explaining, and Rob Sheldon is, as always, on hand to explain with plenty of examples. Read more...

By Additional Articles 2010/09/17 | Source: SimpleTalk | Category: sql server 2008

Rating:

Rate this |

Briefcase | 5,826 reads

T-SQL SQL 2008

By bitbucket 2010/06/21 | Category: t-sql

Rating: (not yet rated) |

Discuss |

Briefcase | 3,877 reads

SQL 2008 MERGE using Dynamic SQL over a Linked Server

Stored Procedure to build a MERGE statement in SQL 2008 using dynamic SQL. Read more...

By Tommy Bollhofer 2010/05/31 | Source: SQLServerCentral.com | Category: sql server 2008

Rating:

|

Discuss |

Briefcase | 2,154 reads

Insert with OUTPUT clause

By vk-kirov 2010/05/19 | Category: triggers

Rating: (not yet rated) |

Discuss |

Briefcase | 3,020 reads

INSTEAD OF trigger and OUTPUT clause

By vk-kirov 2010/05/13 | Category: t-sql

Rating: (not yet rated) |

Discuss |

Briefcase | 3,196 reads

Understanding and Using APPLY (Part 2)

The second of a series by Paul White examining the APPLY operator. In this section learn how this operator compares with joins and about both the cross and outer options. Read more...

By Paul White 2012/01/13 (first published: 2010/04/19) | Source: SQLServerCentral.com | Category: apply

Rating:

|

Discuss |

Briefcase | 19,202 reads

Understanding and Using APPLY (Part 1)

The first of a two-part series of articles examining the APPLY operator. Learn the basics of how this operator works and how it can help you solve some tricky problems. Read more...

By Paul White 2012/01/06 (first published: 2010/04/12) | Source: SQLServerCentral.com | Category: apply

Rating:

|

Discuss |

Briefcase | 32,487 reads

SQL Server 2008 T-SQL Enhancements Part - IV

In the fourth installment that looks at T-SQL changes for SQL Server 2008, Ashad Ali examines how the Filestream data type works. Read more...

By Arshad Ali 2010/03/26 (first published: 2009/08/28) | Source: SQLServerCentral.com | Category: sql server 2008

Rating:

|

Discuss |

Briefcase | 19,378 reads

SQL Server 2008 T-SQL Enhancements Part - III

Continuing with his series on T-SQL enhancements in SQL Server 2008, Arshad Ali brings us a look at the HierarchyID and Large UDTs. Read more...

By Arshad Ali 2010/03/19 (first published: 2009/08/27) | Source: SQLServerCentral.com | Category: sql server 2008

Rating:

|

Discuss |

Briefcase | 24,135 reads

EXECute SQL Commands over entire sets of parameters!

A super-powered EXEC on steroids, the Power Tool every DBA wants for Christmas. Read more...

By RBarry Young 2010/03/16 | Source: SQLServerCentral.com | Category: administration

Rating:

|

Discuss |

Briefcase | 2,635 reads

Beginning T-SQL 2008 - Book Review

A book review of a new T-SQL book for SQL Server 2008, written by longtime SQLServerCentral author and MVP, Kathi Kellenburger. Read more...

By Beverley Beverley 2010/03/15 | Source: SQLServerCentral.com | Category: book reviews

Rating:

|

Discuss |

Briefcase | 1,837 reads

SQL Server 2008 T-SQL Enhancements Part - I

SQL Server 2008 has a number of enhancements over 2005 that make it a more capable platform. New author Arshad Ali brings us an overview and some code about a few T-SQL changes. Read more...

By Arshad Ali 2010/03/05 (first published: 2009/01/22) | Source: SQLServerCentral.com | Category: sql server 2008

Rating:

|

Discuss |

Briefcase | 39,321 reads

Content with tags T-SQL, SQL Server 2008