Database programming with C by Carsten Thomsen

By Carsten Thomsen

Show description

Read or Download Database programming with C PDF

Best data modeling & design books

Designing Database Applications with Objects and Rules: The Idea Methodology

Is helping you grasp the most recent advances in sleek database expertise with thought, a cutting-edge method for constructing, keeping, and utilizing database structures. comprises case reports and examples.

Informations-Design

Ziel dieser Arbeit ist die Entwicklung und Darstellung eines umfassenden Konzeptes zur optimalen Gestaltung von Informationen. Ausgangspunkt ist die steigende Diskrepanz zwischen der biologisch begrenzten Kapazität der menschlichen Informationsverarbeitung und einem ständig steigenden Informationsangebot.

Physically-Based Modeling for Computer Graphics. A Structured Approach

Physically-Based Modeling for special effects: A dependent technique addresses the problem of designing and dealing with the complexity of physically-based types. This publication might be of curiosity to researchers, special effects practitioners, mathematicians, engineers, animators, software program builders and people drawn to computing device implementation and simulation of mathematical types.

Practical Parallel Programming

This is often the publication that may educate programmers to write down quicker, extra effective code for parallel processors. The reader is brought to an unlimited array of systems and paradigms on which genuine coding can be dependent. Examples and real-life simulations utilizing those units are offered in C and FORTRAN.

Additional info for Database programming with C

Sample text

See the example code, which is almost identical to the Microsoft Access code. 45. qxp 3/13/02 3:58 PM Page 398 Part Two: Database Programming View Restrictions A view is almost identical to a row-returning query, with just a few exceptions. Some of the restrictions are detailed here: • COMPUTE and COMPUTE BY clauses cannot be included in your view. • ORDER BY clauses aren’t allowed in a view, unless you specify the TOP clause as part of the SELECT statement. However, you can index a view with SQL Server 2000.

I went into enough details about stored procedures, views, and triggers as to what a C# programmer needs to know, but if you are also responsible for coding the SQL Server database and you need more information and example code, I can certainly recommend you read this book: • Code Centric: T-SQL Programming with Stored Procedures and Triggers, by Garth Wells. Published by Apress, February 2001. ISBN: 1893115836. The next chapter is about hierarchical databases. I’ll discuss how you use the LDAP protocol to access a network directory database like the Active Directory and you’ll see how to access information stored on Exchange Server 2000.

See Chapter 4 for information on the Database Designer. qxp 3/13/02 3:58 PM Page 407 Chapter 6: Using Stored Procedures, Views, and Triggers Creating a Trigger It’s quite easy to create a trigger. This can be done using the Server Manager that comes with SQL Server, but I’ll use the Server Explorer. Here’s how you create a trigger for the example UserMan database: 1. Open up the Server Explorer window. 2. Expand the UserMan database on your database server. 3. Expand the Tables node. 4. Right-click the table for which you want to create a trigger and select New Trigger from the pop-up menu.

Download PDF sample

Rated 4.63 of 5 – based on 38 votes