Search Engine Marketing, SEO, PPC, Affiliate Marke

RSS Feed Homepage

Articles: 1, 2, 3, 4, 5, 6, 7

Building XML Web Services Using C# and ASP.NET - C
2007-02-14 00:58:08
Building XML Web Service s Using C# and ASP.NET - Conclusion (Page 6 of 6 ) In this article we've seen how to create a very simple web service, how to view the details of our web service using WSDL, and also how to put everything we've learnt into one complete authentication web service.In another article I will cover how we can consume the web service we've just made, but until then you should experiment with what you've learnt in this article and also checkout some of the books and links shown below. DISCLAIMER: The content provided in this article is not warrantied or guaranteed by Developer Shed, Inc. The content provided is intended for entertainment and/or educational purposes in order to introduce to the reader key ideas, concepts, and/or product reviews. As such it is incumbent upon the reader to employ real-world tactics for security and implementation best practices. We are not liable for any negative consequences that may result by implementing any information covered ...
More About: Building , Sing , Web Services

Debugging Windows 2000 COM Applications - Conclusi
2007-02-13 12:57:04
Debugging Wind ows 2000 COM Applications - Conclusion (Page 4 of 4 ) I would like to thank MS MSDN as they gave us some tools and direction to locate the problem and resolve the issue. However, in retrospect, it was an easy solution, but so hard to figure out. DISCLAIMER: The content provided in this article is not warrantied or guaranteed by Developer Shed, Inc. The content provided is intended for entertainment and/or educational purposes in order to introduce to the reader key ideas, concepts, and/or product reviews. As such it is incumbent upon the reader to employ real-world tactics for security and implementation best practices. We are not liable for any negative consequences that may result by implementing any information covered in our articles or tutorials. If this is a hardware review, it is not recommended to open and/or modify your hardware.
More About: Cat , Indo

Beginning ASP and Microsoft Access - Name/Value Pa
2007-02-13 12:57:04
Beginning ASP and Micro soft Access - Name /Value Pairs in the URL (Page 3 of 4 ) We now know how to perform some basic SQL commands in ASP. ASP is so efficient for dealing with data as it is simple to code and you can perform all of the necessary actions you would need to do to keep your web site dynamic. Consider CGI pages, where one must use a language like C++ or PERL to manipulate the URL to gather and send information. This is a timely process and requires you to program with more than one file. There are two forms of debugging (i.e. the debugging at the compilation stage and debugging in the browser). All of this is time consuming, and in business, costs money. With ASP you are only using 1 file -- the ASP page itself. Debugging is done in the browser. Another use for ASP is that you can generate a URL and pass the information collected from the user's interaction to the next page. Being a keen web programmer, like myself, you ...
More About: Soft

Beginning ASP and Microsoft Access - Getting Start
2007-02-13 12:57:04
Beginning ASP and Microsoft Access - Getting Star t ed (Page 2 of 4 ) Firstly, we all know how to communicate to a database for an application in Windows using a DSN. If you are not sure or can't remember here is a brief demonstration. By navigating to "Start->Settings->Control Panel->Administrative Tools", we get an icon "Data Sources (ODBC)". If we double click on this icon we would open a window. This is the ODBC Data Source Administrator window. Let's say we wish to communicate to a MS Access database. We select the "System DSN" tab option and click on the "Add..." button: This will open a new window where you select the appropriate driver -- in our case the "Microsoft Access Driver (*.mdb)". When we do this another window will now pop-up, this is dedicated to set up a DSN with properties. We click the "Select..." button and navigate to the MS Access database in the new window. Now click OK:  You will see that you have successfully created a DSN for you...
More About: Soft

Beginning ASP and Microsoft Access
2007-02-13 12:57:04
Beginning ASP and Micro soft Access (Page 1 of 4 )Just starting out with ASP? In this article Ben shows us how to work with an Access database and basic name/value pairs via a form.This article will introduce issues relating to programming in ASP. Focused mainly on database interaction, the issue of security will also be discussed. This article will assume that you have a beginners knowledge of ASP and little or no knowledge of database interaction with Microsoft Access .
More About: Soft

101 Forms and 1 Database Script in ASP - Conclusio
2007-02-13 12:57:04
101 Forms and 1 Data base Script in ASP - Conclusion (Page 4 of 4 ) There you have it. Hopefully you will find this technique very useful in your applications. If you come up with any additions or recommended modifications please come back and let us know. DISCLAIMER: The content provided in this article is not warrantied or guaranteed by Developer Shed, Inc. The content provided is intended for entertainment and/or educational purposes in order to introduce to the reader key ideas, concepts, and/or product reviews. As such it is incumbent upon the reader to employ real-world tactics for security and implementation best practices. We are not liable for any negative consequences that may result by implementing any information covered in our articles or tutorials. If this is a hardware review, it is not recommended to open and/or modify your hardware.
More About: Database , Taba

101 Forms and 1 Database Script in ASP - How To Do
2007-02-13 12:57:04
101 Forms and 1 Data base Script in ASP - How To Do It (Page 2 of 4 ) First, in designing the web architecture for integrating a database, we assume a single data source (Conn). To keep this straightforward, we have a standard 'web form' defining some input variables. Here is our 'web form': In ALL web forms, take a recordset and output to a form object using HTML Textboxes to display the data. In the name property of the textbox put "name=<%=rs("columnName").name%>". In the value property of the same textbox write "value=<%=rs("columnName").value%>" .Insert a 'hidden' input type in the form. The name property is 'Name=xSqlCommand' and value='INSERT'. This represents the sql command you wish to execute. Examples are INSERT, UPDATE, and DELETE.Insert a 'hidden' input with the name property 'name=xTABLE' and value='Tablename'. The Tablename is the database table from which the recordset originates. Often, TableName is server-side as it was used in the SQL sta...
More About: Database

101 Forms and 1 Database Script in ASP
2007-02-13 12:57:04
101 Forms and 1 Data base Script in ASP (Page 1 of 4 )In this article, Matt shows us how to use just one database script to handle all the ASP forms on your site.Imagine adding web forms that will automatically be ready for use with a database. This is not an IDE or simple trick. I think this article will help programmers expand their knowledge of web architecture, as they have not been presented with a different way to handle web forms that present and update a database in ASP. In many cases, web programmers present a web page and 'fill' it with information from the database. If the data is to be updated (inserted or removed), then the data is presented in a form and 'submitted' to a server script to be processed. This method is ok, but assumes a 1 to 1 relationship between the each form and server processing script. Our goal is 'many' web forms and one processing script.
More About: Database , Taba

How to Create ASP Applications Without Writing ASP
2007-02-13 12:57:04
How to Create ASP Applications With out Writing ASP Code - Troubleshooting (Page 3 of 4 ) First and foremost, read IIS and COM Troubleshooting Guide. It pretty much covers all the possible situations and how to get out of them. Are you getting Server.CreateObject failed while checking permissions? Access is denied to this object error or some other permission error? These problems occur mostly (99%) with Windows 2000 or Windows XP Server. They are documented (and several solutions are presented) in Microsoft Knowledge Base article Q259725. Basically, after being severely critisized for lack of security in Windows NT, they really went overboard with it in Windows 2000 and later. For instance, out of the box, you can't debug ActiveX DLLs in Visual Basic 6. You can run them fine, but you can't debug them. Why does this occur? Because when you debug an ActiveX DLL which is being called from IIS, you are doing so with the IUSR_machinename account. Now, IUSR_machinename account has permi...
More About: How To , Cat

How to Create ASP Applications Without Writing ASP
2007-02-13 12:57:04
How to Create ASP Applications With out Writing ASP Code - How it Works (Page 2 of 4 ) So, how does this work? Let us start with basic facts. You will need one VB project. You will need a separate class for each page. That sounds like a lot of work especially if you have a large site. However, these classes are fairly small with no properties, one method and only several functions. Moreover, the classes are similar to each other, so there is going to be a lot of cut & paste. You will also need one ASP file. As this is where the users first touch your web site, it is here where we start to code. Create a file called exec.asp and add lines below to it. <%@ Language=VBScript %> <% dim oInstance, sClass, sProject sClass = Request.QueryString("cls") sProject = Request.QueryString("prj") set oInstance = Server.CreateObject(sProject & "." & sClass) oInstance.ProcessRequest set oInstance = nothing %> From here on out, that is all ASP you will ever have to write. Say g...
More About: How To , Cat

How to Create ASP Applications Without Writing ASP
2007-02-13 12:57:04
How to Create ASP Applications With out Writing ASP Code (Page 1 of 4 )In this article, Robert shows us how to create web applications written in VB, allowing the use of all the features of the VB compiler and debugger.As far as long-term code maintenance is concerned, ASP could be one of the worst environments ever created. I mean, here we have tons of code where logic is barely separated from content and sometimes not at all. Corporations literally are stuck with millions of lines of hard-to-follow ASP code and they will be paying for it in years to come, which is great for developers because it keeps us in business. And don't get me started on debugging ASP. As one of my co-workers says: "You have to dance on one leg and sing a Gypsy song in order to get Interdev to debug ASP code". So, when Paul Sheriff of PDSA (a well-know VB instructor - see his ad in every VBPJ) showed me a working, easily maintainable web application, totally written in VB (not VBScript), except for 6 lines...
More About: How To , Cat

Building a Multi-Page Article System With ASP/PHP
2007-02-13 06:57:05
Building a Multi-Page Article System With ASP/PHP - Conclusion (Page 6 of 6 ) In this article we've seen how to develop a multi-page article publishing system. We've also seen how to list and display each article. The code in this article is rough, however it can be used in a CMS system with a bit of a clean up.
More About: Building , Php

Building a Multi-Page Article System With ASP/PHP
2007-02-13 06:57:05
Building a Multi-Page Article System With ASP/PHP - Displaying a List of Articles (Page 5 of 6 ) It's very easy to display a list of articles from the articles table in our database. We simply loop through the articles table and output the title and summary for each article. We also setup a link to read the entire article, which we will look at shortly. Shown below is the code for both ASP and PHP: ASP Code <!-- #INCLUDE file="db.asp" --> <% objRS.Open "select * from articles order by articleId asc" while not objRS.EOF %> <font face="Verdana" size="4"><b><%=objRS("title") %></b></font><br>< ;br> <font face="Verdana" size="2"> <%=objRS("summary")%><br>< br> <a href="fullarticle.asp?articleId=<%=obj RS("articleId")%>">Read More...</a> </font> <hr><br> <% objRS.MoveNext wend %> PHP Code include("db.php"); $result = mysql_query("select * from articles order by articleId as...
More About: Building , Php

Building a Multi-Page Article System With ASP/PHP
2007-02-13 06:57:05
Building a Multi-Page Article System With ASP/PHP - Saving Articles to the Database (Page 4 of 6 ) When the form is submitted, we have a number of variables available to us. They are:articleTitlearticleSummarypageTitle1 to pageTitle20pageContent1 to pageContent20If you match these up with the schema of our database, then you will see that we have all of the data we need to create entries in our database for each article. We will have 1 entry in the articles table and 1 or more entries in the pages table for each article. Each page is linked back to the article via the articleId field. Let's now look at the code to save an article to the database. ASP Code sub SaveArticle() %><!-- #INCLUDE file="db.asp" --><% dim articleId dim articleTitle dim articleSummary dim arrPages dim objDict dim page dim counter dim i set arrPages = Server.CreateObject("Scripting.Dictionary ") counter = 0 articleTitle = Request.Form("articleTitle") articleSummary = Request.Form("articleSummary") f...
More About: Building , Php

Building a Multi-Page Article System With ASP/PHP
2007-02-13 06:57:05
Building a Multi-Page Article System With ASP/PHP - The JavaScript Behind it All (Page 3 of 6 ) I love JavaScript because it's so flexible and powerful when used correctly (read: not used to popup ad's or confuse you). If you aren't competent with JavaScript then I would highly recommend reading up on it.  Anyway, now to the JavaScript used in our article system. Each button is linked to a JavaScript function. Some of these functions are described below: AddPage This function is activated when the "Add Page" button is clicked. It takes the title and content and adds them to a JavaScript array which is used to keep track of all the pages contained in the new article. Its code looks like this: function AddPage() { var pageTitle = new String(); var pageContent = new String(); var acount = arrTitles.length; var thisForm = document.frmAdd; if(acount < 20) { pageTitle = document.frmAdd.contentTitle.value; pageContent = document.frmAdd.contentBody.value; if(pageTitle.length == 0...
More About: Building , Php

Building a Multi-Page Article System With ASP/PHP
2007-02-13 06:57:05
Building a Multi-Page Article System With ASP/PHP - How Everything Will Work (Page 2 of 6 ) If you're a web developer and have business-orientated clients, then I'm sure that you either have -- or will have to -- construct some sort of content management system to manage articles or content. Some people would like to have you think that CMS's (content management systems) are hard to develop. Don't be fooled. They are easy. The one we are going to build today will let us store and display articles. Each article can have up to 20 pages, each of which will contain a title and some content. We will create one script to create new articles, and another to display them. A MySQL/SQL Server 2000 database will be used to store the articles. The Database Schema Our database will contain just 2 tables: 1 for the articles and 1 for the pages. Each page will link back to its parent article with the use of a primary key in the articles table, and a foreign key in the pages table. MySQL Databa...
More About: Building , Php

Building a Multi-Page Article System With ASP/PHP
2007-02-13 06:57:05
Building a Multi-Page Article System With ASP/PHP (Page 1 of 6 )Interested in building your own CMS? In this article Mitchell shows us how to build a multi-page article system that can be used in any web-based CMS...When I originally started constructing the backend for devArticles.com from my bedroom in early 2001, I never intended to use it as the basis of a commercial product. I remember launching devArticles.com "officially" in November of 2001 to about 3 friends on ICQ and a couple more on mIRC. Back then it was just me. It wasn't much, but it was fun because it was my first ever attempt to create a web site that would serve as both a knowledge base for programmers and as a source of income to get me out of my job, which was developing and designing the TechBuy web site. A couple of months after I launched devArticles.com, things were going smooth and a friend wanted a login to the backend admin area to see how I was adding articles. I gave him access and he really liked the w...
More About: Building , Php

An Article Rating System With ASP - Conclusion
2007-02-13 06:57:05
An Artic le Rating System With ASP - Conclusion (Page 5 of 5 ) In this article we've seen how to create a rating system similar to the one that we use here on devArticles.com. In our example we rated CD's, however this rating system can be used in any sort of setup to rate anything from articles to visitor comments to products, depending on your needs. If you'd like to use this rating system in your own ASP applications, then make sure you download the support material for this file, which you can do at the bottom of this page.
More About: Sion

An Article Rating System With ASP - Showing the ra
2007-02-13 06:57:05
An Article Rating System With ASP - Show ing the ratings (Page 4 of 5 ) Let's assume that several visitors have rated our CD's. We might have 20 different ratings for each CD in the ratings table. If we have a cumulative rating total of 176 and 20 ratings for the first CD in the database, then we would work out the average rating like this: Average Rating = Cumulative Rating Total / Number Of Ratings ... so the average rating for the first CD would be Average Rating = 176 / 20 = 8.8 We want to round the ratings to the closet half number, so 8.8 would be rounded down to 8.5. We will be using ASP to work out the ratings shortly. Before we move on we need to edit showcds.asp. To display the ratings, we will be creating a new function called ShowRating at the end of the showcds.asp file. ShowRating will return the HTML code to display the rating for each CD in a graphical format. Let's take a look at the ShowRating function: function ShowRating(cdId) const MIN_RATINGS_BEFORE_SHOW = 3 ...
More About: Wing

An Article Rating System With ASP - Rate.asp
2007-02-13 06:57:05
An Artic le Rating System With ASP - Rate .asp (Page 3 of 5 ) When a visitor clicks on a rating radio button and then clicks on the "Rate It!" button, a hidden form variable passes the ID of the CD which is being rated as well as the actual rating that the visitor has cast. We don't want any visitor rating one CD more than once because this would introduce bias into the situation, which isn't a good thing. We will grab the visitors IP address and also do some work with cookies to make sure that they can't rate the same CD again. It is practically impossible to stop any dial up user rating a CD more than once. We will be setting a cookie and storing the users IP address in the database, however if they clear their browser's cookies and then reconnect to the Internet with a different IP address then our actions are void.First off, we need to setup rate.asp to grab a couple of variables: <% dim conn dim rs dim cdId dim visitorIP dim rating dim cookie dim cookieRated cdId = Request...

An Article Rating System With ASP - Creating the d
2007-02-13 06:57:05
An Article Rating System With ASP - Creating the database (Page 2 of 5 ) For the sake of this article, let's pretend that we run a web site that sells music CD's. We want each visitor to be able to rate CD's on a scale of 1 to 10, with 1 being the worst and 10 being the best. For our Microsoft Access database we will be using two tables: one to hold the details of each CD, and another to hold the ratings for each CD, as shown below: Each of the tables only contains four fields, which are described below: The cds table: cdId: An autonumber field that gives each CD its own numerical identifier. title: The name of each CD, such as "100% Greatest Hits". artist: The name of the artist who composed the CD. summary: A blurb about the CD and its artist(s). price: The cost of the CD in dollars.The ratings table: ratingId: An autonumber field that gives each rating its own numerical identifier. rating: The actual rating that the user gave to the CD, such as 1, 4, 10, etc. ip: The IP addr...
More About: Eating

Two Ways To Connect To SQL Server 2000 Via ASP - U
2007-02-12 18:56:01
Two Ways To Connect To SQL Serve r 2000 Via ASP - Using system DSN's (Page 2 of 5 ) A Datasource Name (DSN) is a name used to request a connection to a database. DSN's allow you to connect to a database simply by referencing the name of the DSN, and hides the actual details of the database server, user id, password, etc. There are three different types of DSN's:User DSN: A user DSN stores the details of how to connect to a database for the currently logged in user only. If you log off your machine and log back in as a different user, then the DSN will not be accessible. The details of a user DSN are stored on the local computer, within the registry.System DSN: A system DSN stores the details of how to connect to a database. It is accessible by every user on the machine where it was created, including Windows NT services. The details of a system DSN are stored on the local computer, within the registry.File DSN: A file DSN allows you to connect to a data provider and can be shared ...

Two Ways To Connect To SQL Server 2000 Via ASP - U
2007-02-12 18:56:01
Two Ways To Connect To SQL Serve r 2000 Via ASP - Using system DSN's (contd.) (Page 3 of 5 ) Click on the next button to continue with the wizard. If you have already designed a new database or just prefer not to use the master database once you're actually connected to SQL Server (highly recommended: the master database contains several important extended stored procedures and tables that should be treated with care), then change the default database name from "master" to "Northwind", for example.The "Attach Database Filename" text box allows you to attach a database file to your DSN. We won't use this method in our example. Make sure the "Use ANSI quoted identifiers" and "Use ANSI nulls, paddings and warnings" check boxes are checked. They tell SQL server to make sure that in any SQL queries, identifiers containing special characters or match keywords must be enclosed in identifier quote characters. Click the next button to move onto the last tab of the system DSN wizard.All of ...

Two Ways To Connect To SQL Server 2000 Via ASP - U
2007-02-12 18:56:01
Two Ways To Connect To SQL Serve r 2000 Via ASP - Using an OLEDB connection string (Page 4 of 5 ) Now that we've discussed how to use a system DSN to connect to a database via ASP, let's talk about using an OLEDB connection string. A connection string is simply a semi-colon delimited string of text that contains database connection parameters, each represented as a name/value pair.When using a connection string, four of its parameters are actually used by ActiveX Data Objects (ADO). The others are passed onto the provider, which handles the authentication amongst other tasks.Take a look at the example below. It uses an OLEDB connection string to connect to a Microsoft SQL Server 200 database from within ASP:<% Dim conn Set conn = Server.CreateObject("ADODB.Connection") conn.Open "Provider=SQLOLEDB; Data Source = (local); Initial Catalog = Northwind; User Id = sa; Password=" If conn.errors.count = 0 Then Response.Write "Connected OK" End If%>In the example above, the connectio...

Two Ways To Connect To SQL Server 2000 Via ASP - C
2007-02-12 18:56:01
Two Ways To Connect To SQL Serve r 2000 Via ASP - Conclusion (Page 5 of 5 ) Now that you know how to use both system DSN's and OLEDB connection strings, you have to make a choice about which method to use to access your data.Personally, if you run a web site that only receives a couple of hundred visitors a day, then I would recommend using system DSN's. On the other hand, if you receive thousands of visitors a day then speed will be a critical issue, and you should use an OLEDB connection string to gain the extra 10-15% speed differential that's lost when using system DSN's.By reading this article, I hope you now understand how to connect to a database through ASP. If you'd like more examples, or a further explanation of the methods mentioned in this article, then please take a look at the links and books shown below. DISCLAIMER: The content provided in this article is not warrantied or guaranteed by Developer Shed, Inc. The content provided is intended for entertainment and/or...

Two Ways To Connect To SQL Server 2000 Via ASP
2007-02-12 18:56:01
Two Ways To Connect To SQL Serve r 2000 Via ASP (Page 1 of 5 )ASP allows even the newest developer to connect to databases with ease. In fact, the ease with which you can connect to a wide range of databases from within an ASP script is one of the reasons why ASP has become so popular. In this article Joe teaches us how to connect to SQL Server 2000 using system DSN's and an OLEDB connection string.ASP is well known for having an easy to remember language syntax, while still having enough power to allow even the newest developer to connect to databases with ease. In fact, the ease with which you can connect to a wide range of databases from within an ASP script is one of the reasons why ASP has become so popular.In this article I'm going to show you two different methods that you can use to connect to a Microsoft SQL Server 2000 database: System DSN's and the OLEDB connection string. I will explain the positives and negatives of each method, and I will also provide you with some e...

SQL Server 2000, XML and XSL: The Ultimate Combina
2007-02-12 18:56:01
SQL Server 2000, XML and XSL: The Ultimate Comb ination - Conclusion (Page 5 of 5 ) Microsoft has successfully implemented XML support into their overall Web strategy, and this is blatantly obvious in SQL Server 2000. If some of the code above was a bit hard to understand, persevere. It took me almost two weeks to learn when I first started!The stored procedure we created is just one of the many ways to incorporate XML into the business logic layer of any n-Tier application, keeping in mind that many, if not all of the world's top development companies have already incorporated/are planning to incorporate XML support into their products. Try the related links and books below to broaden your knowledge of XML in SQL Server 2000. DISCLAIMER: The content provided in this article is not warrantied or guaranteed by Developer Shed, Inc. The content provided is intended for entertainment and/or educational purposes in order to introduce to the reader key ideas, concepts, and/or product revi...
More About: Mate , The U

SQL Server 2000, XML and XSL: The Ultimate Combina
2007-02-12 18:56:01
SQL Server 2000, XML and XSL: The Ultimate Comb ination - Displaying the XML with ASP and XSL (Page 4 of 5 ) Now that we've created our stored procedure named "sp_GetExplicitXML", we'll want to be able to do something useful with it. We can start by making sure the stored procedure returns the results we expected by typing the following code into a new query analyser window:use myProductsgoexec sp_GetExplicitXMLIf all goes well, you'll be presented with one row of XML that contains the results of the stored procedure. To display our results in a browser, we'll create an ASP script that will execute the stored procedure, load the results into an MSXML DomDocument object, and then transform those results using an XSL stylesheet. Create a new ASP script and call it prodtest.asp. Enter the following code into prodtest.asp and save it into a directory that can be processed by IIS:<!-- METADATA Type="TypeLib" File="c:program filescommonfilessystemadomsado15.dll" --><%dim ...
More About: Mate , The U

SQL Server 2000, XML and XSL: The Ultimate Combina
2007-02-12 18:56:01
SQL Server 2000, XML and XSL: The Ultimate Comb ination - Creating the stored procedure (Page 3 of 5 ) To retrieve our data as XML, we will compress our query batch into a single stored procedure. This encourages code reuse strategies and is easily modifiable in the future. Lets start by loading up query analyzer on our database server (Start -> Programs -> Microsoft SQL Server -> Query Analyzer).When prompted, enter your database login credentials. You should be connected to the server on which you created the "myProducts" database. Next, enter the following T-SQL commands, which I will explain shortly:use myProductsgoCREATE PROCEDURE sp_GetExplicitXMLAS SELECT 1 AS Tag, NULL AS Parent, c.catName as [Category!1!CatName], NULL as [Product!2!ProdName], NULL as [Product!2!Description] FROM categories cUNION ALL SELECT 2 AS Tag, 1 AS Parent, c.catName, p.productName, d.descText FROM categories c, products p, descriptions d WHERE c.catId = p.productCat AND p.productId = d.descPr...
More About: Mate , The U

SQL Server 2000, XML and XSL: The Ultimate Combina
2007-02-12 18:56:01
SQL Server 2000, XML and XSL: The Ultimate Comb ination - Creating our sample database (Page 2 of 5 ) On your SQL Server, open Enterprise Manager and create a new database named "myProducts". Then, using either Enterprise Manager or Query Analyzer, create the tables shown below:(Note: catId, productId and descId are all auto-incrementing identity fields)As you've probably guessed, we're using three tables to simulate a very simple product description database (let's assume we sell books). The diagram above shows the hierarchy of our data: categories listing products, listing their descriptions. Before we progress to the next step, we'll need to create some dummy data in our tables. To maximize productivity and minimize the length of this article, I've created a simple T-SQL script, which will populate our tables as needed. You can download it as part of the support material at the end of this article. The script will create 3 categories, 7 products and 7 descriptions.
More About: Mate , The U