Results 261 to 270 of about 82,951 (280)
Some of the next articles are maybe not open access.
2004
Current Geographic Information Systems (GISs) are inadequate for performing spatial analysis, since they force users to formulate their often vague requests by means of crisp selection conditions on spatial data. In fact, SQL extended to support spatial analysis is becoming the de facto standard for GISs; however, it does not allow the formulation of ...
G Bordogna, G Psaila
openaire +3 more sources
Current Geographic Information Systems (GISs) are inadequate for performing spatial analysis, since they force users to formulate their often vague requests by means of crisp selection conditions on spatial data. In fact, SQL extended to support spatial analysis is becoming the de facto standard for GISs; however, it does not allow the formulation of ...
G Bordogna, G Psaila
openaire +3 more sources
2003
Publisher Summary This chapter focuses on working with dynamic Structured Query Language (SQL). The easiest way to work with dynamic SQL is the EXECUTE IMMEDIATE statement. To use it, store a SQL command in a host language string variable and then submit that command for process.
openaire +3 more sources
Publisher Summary This chapter focuses on working with dynamic Structured Query Language (SQL). The easiest way to work with dynamic SQL is the EXECUTE IMMEDIATE statement. To use it, store a SQL command in a host language string variable and then submit that command for process.
openaire +3 more sources
2020
In the earlier chapters in the section on “Building Understandable T-SQL,” I have covered the various data types available and how to select the correct data type. I have also discussed several database objects available when you write your T-SQL and the pros and cons of using each database object. In the previous chapter, I explained the importance of
openaire +2 more sources
In the earlier chapters in the section on “Building Understandable T-SQL,” I have covered the various data types available and how to select the correct data type. I have also discussed several database objects available when you write your T-SQL and the pros and cons of using each database object. In the previous chapter, I explained the importance of
openaire +2 more sources
2011
Publisher Summary Structured Query Language (SQL) is one of the most common languages today for directly interacting with databases and comparable systems. Most Web applications providing interactive content use databases and are usually fueled by database management systems (DBMSs) such as MySQL, PostgreSQL, or Oracle, all of which are capable of ...
Mario Heiderich +3 more
openaire +2 more sources
Publisher Summary Structured Query Language (SQL) is one of the most common languages today for directly interacting with databases and comparable systems. Most Web applications providing interactive content use databases and are usually fueled by database management systems (DBMSs) such as MySQL, PostgreSQL, or Oracle, all of which are capable of ...
Mario Heiderich +3 more
openaire +2 more sources
2003
Publisher Summary This chapter provides an overview of embedded SQL. Although a knowledgeable SQL user can accomplish a great deal with an interactive command processor, much interaction with a database is through application programs that provide a predictable interface for non-technologically sophisticated users.
openaire +3 more sources
Publisher Summary This chapter provides an overview of embedded SQL. Although a knowledgeable SQL user can accomplish a great deal with an interactive command processor, much interaction with a database is through application programs that provide a predictable interface for non-technologically sophisticated users.
openaire +3 more sources
2005
Publisher Summary This chapter presents tips and suggestions on optimizing SQL. The query optimizers depend on the underlying architecture and are simply too different for many universal rules. A rule-based optimizer parses a query and executes it in the order in which it was written, by doing some reorganization of the query into an equivalent form ...
openaire +3 more sources
Publisher Summary This chapter presents tips and suggestions on optimizing SQL. The query optimizers depend on the underlying architecture and are simply too different for many universal rules. A rule-based optimizer parses a query and executes it in the order in which it was written, by doing some reorganization of the query into an equivalent form ...
openaire +3 more sources
Verschachtelte Anfragen in SQL
2011Nachdem in den letzten beiden Kapiteln alle Grundlagen fur einfache Anfragen, die unterschiedlichen syntaktischen Moglichkeiten und die verschiedenen Herangehensweisen an die Anfragenerstellung gezeigt wurden, steht in diesem Kapitel die Moglichkeit zur Verknupfung von Anfragen im Mittelpunkt.
openaire +2 more sources