Results 91 to 100 of about 5,624,338 (129)

Stored Procedures and Passing Parameters

1999
When we refer to stored procedures in terms of Microsoft Access we are really referring to queries. The large scale, enterprise relational databases refer to queries as stored procedures. So, what is a stored procedure? It depends on whom you ask. Basically, a stored procedure is a set of logical SQL code that selects columns and rows of data from one ...
Thearon Willis, Kevin Spencer, John Kauffman   +2 more
openaire   +2 more sources

System Stored Procedures

2001
There are three types of stored procedures available in SQL Server 2000: system, extended, and user-defined. This chapter concentrates on system stored procedures. Extended stored procedures are covered in Chapter 10, and the basics of user-defined stored procedures are covered in Chapter 11.
openaire   +2 more sources

Dynamic Store Procedures in Database

2017
In production of applied software, different methods have been proposed for communication with the database (Feizi et al. 2010). These methods are generally classified in two main groups. In the first method, questions are usually written in the program section and inside the code.
Muhammet Dursun Kaya, Hasan Asil
openaire   +2 more sources

Preventing SQL injection attacks in stored procedures

Australian Software Engineering Conference (ASWEC'06), 2006
An SQL injection attack targets interactive Web applications that employ database services. These applications accept user inputs and use them to form SQL statements at runtime. During an SQL injection attack, an attacker might provide malicious SQL query segments as user input which could result in a different database request.
K. Wei, Suraj C. Kothari, M. Muthuprasanna   +2 more
openaire   +2 more sources

Stored Procedures, Functions, and Security

2012
Now that you know how to build queries written as single executable lines of T-SQL statements, it is time to look at how to place these into a stored procedure or a function within SQL Server, allowing them to be run as often as they are required without the need to be retyped every time.
openaire   +2 more sources

An analytical procedure for asymmetric store flutter

The Aeronautical Journal, 1999
AbstractA simple but effective method is presented to analyse the effects of asymmetric external stores on flutter of an aircraft in this paper. The method is a kind of ‘direction derivative’ technique, and can be easily applied to predict whether the asymmetric external stores increase or decrease the flutter speed.
openaire   +2 more sources

Stored Procedures—Part 2

2015
The last chapter taught you pretty much all you need to know to start creating stored procedures. We’ll enhance that knowledge in this chapter by introducing user-defined data types (UDT for short) and taking a detailed look at set-based logic. It’s one of the most important things you need to understand as a database developer, and once you understand
openaire   +2 more sources

Natively Compiled Stored Procedures

2014
Now that disk-based stored procedures have been covered it’s time to look at natively compiled stored procedures. These procedures are built to execute against in-memory tables as quickly and as efficiently as possible. For the most part, the functionality available in standard stored procedures exists within natively compiled stored procedures, but ...
openaire   +2 more sources

Stored Procedures—Part 1

2015
Stored procedures—or SPs, as some lovingly call them—are likely to become your best friends as you spend more and more time with SQL Server. It is not uncommon to come across databases that contain hundreds of stored procedures—they’re just so darned flexible! In this chapter, we’ll find out exactly why stored procedures are so useful, and we’ll create
openaire   +2 more sources

Stored Procedure

SQL, 2019
R. Adams
semanticscholar   +1 more source