Below you will find pages that utilize the taxonomy term “SQL Server”

Chinook SQL Server Database

The Chinook Database is a sample database available for SQL Server, Oracle, MySQL, PostgreSQL, SQL Server Compact, SQLite and more. It is ideal for demos, application prototypes and perhaps even a digital media store application. It includes tables for artists, albums, media tracks, invoices and customers. Download and Installation Download the Chinook database from GitHub. Chinook Database Make sure you can Access your SQL Server [Configure Windows Firewall]

jQuery - MSSQL Pagination and Data Templates

Here is a tutorial to show you how to paginate JSON data in the client using jQuery, jQuery Templates plugin, ASP.NET and SQL Server. For this tutorial, you will need: jQuery version 1.4.2 or greater [jquery.com] jQuery Pager plugin [github.com/jonpauldavies/jquery-pager-plugin] jQuery Templates plugin [github.com/jquery/jquery-tmpl] Visual Studio and SQL Server [msdn.microsoft.com] using Visual Studio 2010 with SQL Server Express in this tutorial. other versions may work (untested). Chinook database [github.

Arrays and Lists in SQL Server 2008

I sure hope this article will help solve a problem for me: http://www.sommarskog.se/arrays-in-sql-2008.html” . It sure looks promising since the opening paragraph pretty much asks my question and the remainder of the article addresses it with solutions. I would like to pass an array of id’s as a single parameter to a stored procedure. Another solution to consider is passing the id’s as an XML string, and then parse the XML into a temp table to join against, or a query against the XML directly using SP_XML_PREPAREDOCUMENT and OPENXML.