- SQL Server String, Cursor, Security and Rowset Functions
- Apr 18, 2003
- Baya Pavliashvili continues his series on system-supplied functions by discussing the string, security, cursor, and rowset functions. Also discover some extra features, which are not mentioned in the SQL Server online documentation.
|
- SQL Server User-Defined Functions (UDFs)
- May 2, 2003
- When you can't find a built-in function that meets your needs, you can write your own. This fifth article continues Baya Pavliashvili's series on system-supplied functions by introducing you to various types of user-defined functions (UDFs). Learn about their syntax and situations in which each one is useful.
|
- SQL Server: Advantages and Drawbacks of User-Defined Functions
- May 16, 2003
- Why are UDFs important? What can you do with UDFs that you can't do with stored procedures? Although UDFs are not functionally stronger than stored procedures, they do provide certain advantages. Baya Pavliashvili discusses the advantages and limitations that are associated with UDFs and shows you the coding tasks that qualify as good candidates for UDFs.
|
- SQL Standards and Guidelines for DB2 Developers
- Oct 15, 2012
- This chapter shows how to create a set of SQL standards and guidelines for developers to follow when running applications that involve DB2.
|
- Statement Permissions
- Nov 6, 2000
- Statement permissions allow a database user, database role, or Windows user or group to perform various tasks such as creating databases, creating objects, or backing up the database. Statement permissions allow a user to run a particular command (or ...
|
- Summarizing Data Results from a SQL Query
- Oct 18, 2002
- In this lesson, aggregate functions are explained by example, providing the reader with a solid foundation that can be applied to empower the database query.
|
- The Database Normalization Process
-
By
Ryan Stephens
- Jan 24, 2003
- Find out what normalization is and how your database can benefit from it (or suffer from it). Learn the advantages, disadvantages, and some techniques and guidelines to doing it yourself.
|
- The Simplest SQL Notification Application: Stock Quotes
- Oct 8, 2004
- This chapter by Shyam Pather introduces you to the basics of SQL-NS and shows you how coding in this environment works.
|
- T-SQL Enhancements in SQL Server 2005
- Jul 30, 2004
- SQL Server 2005 includes a plethora of new features and tools that can help developers more efficiently and effectively manage data. This article provides a preview of the new features and their use.
|
- Using CLR Integration in SQL 05 for Writing Stored Procedures
- Apr 13, 2007
- Join Jesse Smith to learn more about writing stored procedures using a .NET-based language with SQL Server 2005.
|
- Using Entity SQL As Your Data Access Layer
- Dec 2, 2008
- Learn why you should let the ADO.NET Entity Framework be your data access layer.
|
- Using LINQ to SQL in an ASP.NET Application
- Apr 9, 2008
- Build database-driven ASP.NET applications by taking advantage of LINQ to SQL.
|
- Using MySQL Client Programs
- Jul 23, 2004
- This chapter discusses general principles that are common to most MySQL client programs. It also describes how to use several specific types of clients. Sample questions with detailed answers are provided at the end of the chapter to help you prepare.
|
- Using the SELECT Statement to Retrieve Data in SQL
- Oct 14, 2015
- In this lesson from Oracle PL/SQL in 10 Minutes, Sams Teach Yourself, you’ll learn how to use the SELECT statement to retrieve one or more columns of data from a table.
|
- Video: Learning SQL: Retrieve Individual Columns
- Nov 13, 2015
- In this excerpt from Learning SQL LiveLessons (Video Training), Ben Forta looks at a simple SELECT statement that will retrieve a single column from a table.
|
- Video: Learning SQL: Review Database Basics
- Nov 17, 2015
- In this excerpt from Learning SQL LiveLessons (Video Training), Ben Forta covers database basics, including what a database is, the purpose of tables, columns and rows, relational databases, and keys.
|
- Video: Learning SQL: Use the SELECT Statement
- Nov 19, 2015
- In this excerpt from Learning SQL LiveLessons (Video Training), Ben Forta shows you how to use the SQL statement that you will use the most: The SELECT statement.
|
- Video: Oracle SQL: Exploring Date Functions
- Nov 20, 2015
- In this excerpt from Oracle SQL LiveLessons (Video Training), Downloadable Version, Dan Hotka shows you how to work with date functions and date format functions.
|
- Video: Oracle SQL: Understanding Multiple Table Joins
- Nov 24, 2015
- In this excerpt from Oracle SQL LiveLessons (Video Training), Downloadable Version, Dan Hotka discusses table joins.
|
- Video: Oracle SQL: Use Analytical Functions
- Nov 26, 2015
- In this excerpt from Oracle SQL LiveLessons (Video Training), Downloadable Version, Dan Hotka discusses analytical functions.
|