Results 281 to 290 of about 2,044,947 (320)
Some of the next articles are maybe not open access.
2020
One of the most common issues continually facing IT organizations is finding the proper balance between the effort to develop and deploy processes into production against the efficiency and effectiveness of production control operators. The effort to develop and deploy and the effectiveness of production control seem to be diametrically opposed. Making
Andy Leonard, Kent Bradshaw
openaire +1 more source
One of the most common issues continually facing IT organizations is finding the proper balance between the effort to develop and deploy processes into production against the efficiency and effectiveness of production control operators. The effort to develop and deploy and the effectiveness of production control seem to be diametrically opposed. Making
Andy Leonard, Kent Bradshaw
openaire +1 more source
2003
Welcome to the SQL Server 2000 Stored Procedures handbook. Here, we will cover the different types of stored procedures used in SQL Server 2000 and their usage. We will also examine the working of stored procedures, the potentially tricky areas, and how to avoid them.
Tony Bain +3 more
openaire +1 more source
Welcome to the SQL Server 2000 Stored Procedures handbook. Here, we will cover the different types of stored procedures used in SQL Server 2000 and their usage. We will also examine the working of stored procedures, the potentially tricky areas, and how to avoid them.
Tony Bain +3 more
openaire +1 more source
2003
In the previous chapter, you saw how you can store a SQL query in a Relational Database Management System (RDBMS) as a view, making it easy to access complex, shaped data without having to use a lengthy query. Stored procedures fulfill a similar role but do so in a much more powerful way.
Cristian Darie +4 more
openaire +1 more source
In the previous chapter, you saw how you can store a SQL query in a Relational Database Management System (RDBMS) as a view, making it easy to access complex, shaped data without having to use a lengthy query. Stored procedures fulfill a similar role but do so in a much more powerful way.
Cristian Darie +4 more
openaire +1 more source
2003
We could write a whole book only on system stored procedures. In fact someone already has; it’s written by the Microsoft SQL Server team and is available under the System Stored Procedures section, which is included under the Transact-SQL Reference section of SQL Server Books Online.
Tony Bain +3 more
openaire +1 more source
We could write a whole book only on system stored procedures. In fact someone already has; it’s written by the Microsoft SQL Server team and is available under the System Stored Procedures section, which is included under the Transact-SQL Reference section of SQL Server Books Online.
Tony Bain +3 more
openaire +1 more source
2015
A stored procedure groups one or more Transact-SQL statements into a logical unit, stored as an object in a SQL Server database. When a stored procedure is executed for the first time, SQL Server creates an execution plan and stores it in the plan cache. SQL Server can then reuse the plan on subsequent executions of this stored procedure.
Jason Brimhall +2 more
openaire +1 more source
A stored procedure groups one or more Transact-SQL statements into a logical unit, stored as an object in a SQL Server database. When a stored procedure is executed for the first time, SQL Server creates an execution plan and stores it in the plan cache. SQL Server can then reuse the plan on subsequent executions of this stored procedure.
Jason Brimhall +2 more
openaire +1 more source
Working with Stored Procedures
2002This chapter looks at some of the more common objects you need to understand when working with Access Data Projects (ADPs) and SQL Server. Stored procedures, functions and views form the cornerstone of much of this interaction. To quote Russell Sinclair, author of From Access to SQL Server (Apress): “Stored procedures are a new concept to most Access ...
Susan Sales Harkins, Martin W. P. Reid
openaire +1 more source
2001
Chapter 17 introduced stored procedures and provided the basic syntax for their use as well as some simple examples. Stored procedures encompass quite a bit more and deserve some additional attention. The syntax allows for sophisticated construction of related, interdependent operations as well as graceful error control.
openaire +1 more source
Chapter 17 introduced stored procedures and provided the basic syntax for their use as well as some simple examples. Stored procedures encompass quite a bit more and deserve some additional attention. The syntax allows for sophisticated construction of related, interdependent operations as well as graceful error control.
openaire +1 more source
2011
When I first discovered Java stored procedures, I made a formal presentation of my findings to the IT department of the company where I worked, giving several examples, including using Java in an Oracle database to send e-mail, to read web pages, and to calculate Unix crypt values for the authentication of application users. That was in 2001, and as we
openaire +1 more source
When I first discovered Java stored procedures, I made a formal presentation of my findings to the IT department of the company where I worked, giving several examples, including using Java in an Oracle database to send e-mail, to read web pages, and to calculate Unix crypt values for the authentication of application users. That was in 2001, and as we
openaire +1 more source
2012
A stored procedure is a collection of SQL statements that allows you to perform a task repeatedly. You can create the procedure once and reuse it any number of times in your program. This can improve the maintainability of your application and allow applications to access the database in a uniform and optimized manner.
openaire +1 more source
A stored procedure is a collection of SQL statements that allows you to perform a task repeatedly. You can create the procedure once and reuse it any number of times in your program. This can improve the maintainability of your application and allow applications to access the database in a uniform and optimized manner.
openaire +1 more source