This article by Erlend Dalen, explains the different options to use when you need to search and retrieve a set of data from the database. It shows you how to create a query, how to create a view, and how to write different select statements.
In this article, you will learn about the different methods of retrieving data from the database. They are as follows:
- Queries which are reusable and often used in reports and periodic Jobs
- Views that are created in AOT and translated to optimized select statements at runtime
- Select statements to use in X++ to fetch data from the database to the application
This article by Dr. Jayaram Krishnaswamy, shows how you may retrieve XML data from a relational database and write it to a folder on your file system as a text or xml file using Microsoft SQL Server Integration Services 2008. The following are the different steps involved in this EL process (there being no transformation):
- Creating a stored procedure that retrieves XML
- Creating a package in BIDS or Visual Studio 2008
- Adding and configuring a ExecuteSQL task
- Adding and configuring a Script task
- Running the package and verifying the results
This article by Rahul Pitre, will help you try your hands at writing your own HTML mark up to tweak your site.How to install off-the-shelf components to enhance your website is the next skill you'll learn in this article. You'll install a custom FAQ component because the built-in FAQ page doesn't work as advertised.
In this article you will:
- Add an HTML module to your page.
- Write HTML in the HTML module. Chances are that you don't know a lot about HTML. So, you'll take a crash course on a small subset of HTML that will help you to get started with writing your own markup, if you so desire.
- Perform some common page-building tasks such as embedding flash movies, PayPal buttons, and other such external content in your web pages using the HTML module.
- Download and install an FAQ solution that renders a customized FAQ page.
In this article by Rahul Pitre you'll start using the design tools to personalize your site's headers and footers. You'll customize its name and slogan, and in the bargain put your distinctive stamp on your website.
In this article, you will:
- Decide what your website's title should be, and set it in your template
- Decide what your website's slogan should be, and set it in your template
- Decide what information should go into your website's footer, and set it