Do you want to improve your T-SQL skills? MVP Jacob Sebastian runs regular challenges to get you to think about how to solve a problem in T-SQL. These run monthly and we have a summary and explanation from challenge #1 to help you learn more about moving data from 3 tables into a specific format.
2009-09-14
9,850 reads
This next few installments of this series from MVP Jacob Sebastian will deal with how to modify XML documents. Part 1 looks at XQUERY.
2009-07-22
6,750 reads
MVP Jacob Sebastian has written a great series on working with XML in SQL Server and we have the latest installment today. This time he presents a library of functions that can produce an RSS ATOM compliant feed of data.
2009-02-25
3,951 reads
SQL Server 2008, code named Katmai, has some very interesting additions to the SQL Server platform to make your development tasks easier. One of these is passing a table variable as a parameter to a stored procedure and regular columnist Jacob Sebastian shows us how.
2009-02-13 (first published: 2007-09-12)
34,303 reads
Continuing on with his series on SQL Server 2008, MVP Jacob Sebastian brings us a look at the debugger, which has returned in SQL Server 2008.
2008-10-15
5,875 reads
RSS feeds are becoming almost required for any type of data publication. SQL Server MVP Jacob Sebastian brings us the next installment of his XML Workshop series that looks at a series of T-SQL functions to generate the RSS formatted data.
2008-10-01
3,061 reads
Continuing on with his series on XML, Jacob Sebastian looks at some more advanced XML techniques in SQL Server 2005.
2008-09-25 (first published: 2007-05-09)
29,486 reads
SQL Server MVP Jacob Sebastian starts a new series looking at the changes in SQL Server 2008 to the management tools.
2008-07-30
7,233 reads
This long running, and very popular, XML series continues with a look at building an ATOM feed with SQL Server.
2008-07-16
2,688 reads
In a followup to his article on SQL Server Everywhere, Jacob Sebastian takes a more in-depth look at the smallest platform for SQL Server, Compact Edtion.
2008-06-05 (first published: 2007-07-10)
11,274 reads
Welcome back, my fellow sleuths, to my mystery-inspired blog series! I’m having a ton...
By Steve Jones
This was one of the original values: The facing page has this text: No...
By Chris Yates
For decades, enterprises have thought about data like plumbers think about water: you build...
Comments posted to this topic are about the item Create an HTML Report on...
Comments posted to this topic are about the item I Love Editorials
Hi everyone I have a 1000 plus line query and I am getting an...
What happens when I run this code:
DECLARE @s VARCHAR(1000) = 'apple, pear, peach' SELECT * FROM STRING_SPLIT(@s, ', ')See possible answers