 - In computing, a library is a collection of similar objects that are stored for occasional use - most frequently, programs in source code or object code form, data files, scripts, templates, fonts, and physical storage units such as tape cartridges. Here are some common types of libraries.
1) A program library is a collection of (usually) precompiled, reusable programming routines that a programmer can "call" when writing code so that the programmer doesn't have to write it. A dynamic link library (DLL) is one type of program library. Another type of program library is a class library, whose stored routines are class definitions in object-oriented programming (OOP). Graphical user interface (GUI) components such as scroll bars, buttons, and windowing routines are generally stored in a class library.
2) A storage library is a collection of physical storage media such as tapes or disks and a way to access them. A tape library, for example, contains tape cartridges and a mechanism that moves them into and out of the drive(s) where their content is read or updated.
3) A data library is the area of a data center (a centralized area housing computer systems and equipment) where storage media are archived. online service providers also sometimes refer to a directory on a server containing files for downloading as a data library.
4) A virtual library is simply the online version of the traditional library. Books and documents are made available over the Web, and may be read on line or downloaded.
 |
Learn more about SQL Server Stored Procedures |
| SQL Server stored procedures tutorial: Write, tune and get examples: Learn how to write and tune SQL Server stored procedures in this tutorial. Also included is a collection of stored procedure examples for you to browse. |
| Find size of SQL Server tables and other objects with stored procedure: Check the size of SQL Server tables and other database objects with an original stored procedure, sp_SOS, that expands on sp_spaceused. Calculate space and perform more functions. |
| Stored procedure to find fragmented indexes in SQL Server: Here's a stored procedure to find fragmented indexes on all servers and databases in SQL Server environments and improve application performance. |
| Examples of SQL Server stored procedures and parameters: Find examples of SQL Server stored procedures and parameters not documented by Microsoft. |
| FAQ: SQL Server stored procedure how-tos: Write and run SQL Server stored procedures more effectively. This collection of FAQs will start you on the path to working with useful T-SQL routines. |
| Stored procedure: A simple way to perform crosstab operations: SQL Server crosstab operations usually involve complicated T-SQL coding. This tip explains how the process is made simple with the sp_Crosstab stored procedure. |
| Stored procedure to monitor long-running jobs in SQL Server 2000: Get a stored procedure to monitor long-running jobs in SQL Server 2000. This T-SQL stored procedure (SP) also provides email alerts about jobs that decrease SQL Server performance. |
| Stored procedure: Execute T-SQL code from a file: Existing routines to execute T-SQL code from a file without using osql and xp_cmdshell, have many limitations. The sp_ExecuteSQLFromFile stored procedure addresses the shortcomings |
| CLR stored procedures versus T-SQL stored procedures: How do CLR stored procedures and functions perform compared to T-SQL stored procedures and functions? |
| Sample T-SQL stored procedure: P_DisplayProductDetails: This sample T-SQL stored procedure to be debugged displays product details from the AdventureWorks database using a function to rank the unit price for each product subcategory. |
| Stored procedures: Find columns and tables: Continuing our stored procedure series, this simple routine is handy for finding columns by name and listing the table(s) in which they exist. |
| Top 10 SQL Server development tips of 2008: From converting date/time values into character types to retrieving XML data values with XQuery, these were the top 10 SQL Server development topics of 2008. |
| SQL Server and data manipulation in T-SQL: Learn about stored procedures, parameters, triggers and other T-SQL code functions in this book excerpt. |
| SQL Server stored procedures tutorial: Write, tune and get examples: Learn how to write and tune SQL Server stored procedures in this tutorial. Also included is a collection of stored procedure examples for you to browse. |
| Top 10 SQL Server development questions: SQL Server development can put you in a crunch. Get solutions here when it comes to concurrency problems, stored procedure results and writing T-SQL. |
| FAQ: SQL Server stored procedure how-tos: Write and run SQL Server stored procedures more effectively. This collection of FAQs will start you on the path to working with useful T-SQL routines. |
| LAST UPDATED: |
01 Apr 2005
|
 |
Do you have something to add to this definition? Let us know.
Send your comments to techterms@whatis.com
|
|
Show me everything on 
