What if you want to send SQL to no particular database system and want your SQL to work with any data store you configure?
如果您想将SQL发送到非特定数据库系统,并想使用SQL处理您配置的任何数据存储,该怎么做?
You have now captured the SQL in your application and bound the SQL to create database packages in preparation to execute it using static SQL.
现在您已经捕获了应用程序中的SQL并绑定了SQL以创建准备使用的数据库包,以使用静态SQL执行它。
SQL statement distribution shows the distribution of dynamic and static SQL statements for a database.
SQL语句分布图显示数据库的动态和静态 SQL语句的分布情况。
Here is how an SQL injection works: First, assume an SQL statement accepts user-supplied data to look up a team member's contact information from a database without input validation rules.
下面是SQL注入的工作方式:首先,假设一条sql语句接受用户提供的数据,没有输入确认规则就可在数据库中查找团队成员的联系信息。
Using this composite SQL file avoids the need to run the individual module project SQL scripts and simplifies the database configuration process.
使用这个合成sql脚本,您无需运行每个模块项目sql脚本,从而简化了数据库配置过程。
When optimizing SQL queries, the decisions made by the SQL compiler are heavily influenced by the optimizer's model of the database contents.
当对SQL查询进行优化时,SQL编译器所做出的决定会受到优化器的数据库内容模型的重大影响。
With the property set this way, any SQL statements from the application that are not bound to the database will result in an SQL error.
采用这种方式设置该属性,应用程序中任何未绑定到数据库的sql语句都将产生SQL错误。
Effective team development is made possible by having information about all SQL used in the application and database affected by each SQL at the developer's fingertips.
开发人员能够随时掌握应用程序中使用的所有SQL或每条影响数据库的sql语句的信息,这使有效的团队开发成为可能。
Although EJBQL is a subset of true SQL, it provides abstraction so that no manual editing of SQL is necessary when changing database vendors.
尽管EJBQL只是真正SQL的子集,但是它进行了抽象,所以在更改数据库厂商时不需要手工编辑SQL。
In addition, any bugs that occur when the SQL schema doesn't match the database access code are all but eliminated because the generator builds both the SQL schema and the access code.
此外,由于SQL架构与数据库访问代码不匹配造成的缺陷也可以完全避免,因为SQL架构和访问代码都是由生成器建立的。
All SQL comparisons, SQL query execution, and SQL casting takes place in the database code page.
所有SQL比较、SQL查询执行以及SQL类型转换都必须在数据库代码页中进行。
A language so similar to SQL would seem to want to return column sets (tuples), like SQL does, but an object database doesn't work that way — it wants to return objects, not arbitrary sets.
类似于SQL的语言要求返回列集(元组),与SQL相同,但是对象数据库不会以这种方式工作——它希望返回对象,而不是随机集。
SQL is generated by frameworks not programmers, database connections are managed by systems administrators not DBAs, and dynamic SQL complicates security management.
SQL是由框架而不是程序员生成的,数据库连接是由系统管理员而不是DBA 管理的,并且动态 SQL 还增加了安全管理难度。
Now that you have captured your SQL, you need to bind the SQL in that capture file to the target database, and this creates the package.
捕获sQL之后,需要将捕获文件中的SQL绑定到目标数据库,这样就会创建包。
A good solution to a problem you may encounter when working with a database is to print out your SQL statements to make sure that what you are executing SQL you intended to execute.
对于使用数据库时可能遇到的问题,一个好的解决方案是输出sql语句,以确保执行的SQL就是想要执行的。
You cannot transfer a database from one SQL server (to a different SQL server) if the two servers have different server default collation Settings.
如果两个SQL服务器拥有不同的服务器默认校对设置,那么您不能将一个数据库从一个SQL服务器传输到另一个SQL服务器。
We edited the SQL script file and changed the first two SQL statements to indicate the desired database name
我们编辑了SQL脚本文件,并更改了前两个 SQL语句,以指示希望使用的数据库名称
The default Settings for the MembershipProvider in this case USES SQL Server Express Edition but can be made to with SQL Server or some existing database.
默认设置的MembershipProvider使用了SQLServer快速版,不过您也可以使用其他SQL Server版本,或者已存在的数据库。
The SQL Explorer page displays a summary of all SQL statement types that have been executed on the current database server.
SQLExplorer页面显示在当前数据库服务器上执行的所有sql语句类型的汇总信息。
Once the data is in the SQL Server database, SQL can be used to perform the translation and load the result table.
在将数据装载到SQLServer数据库之后,可以使用 SQL执行转换和装载结果表。
If you use databases on a daily basis, but SQL isn't your strong suit, read the Art of SQL. It's a well-written, practical guide to getting the most out of a database.
如果您每天使用数据库,但是不熟悉SQL,那么请阅读TheArtof SQL,这本书写得很好,实践性也很强,可以指导您基本了解数据库。
After you enable SQL passthrough, when an SQL query is executed from the application, solidDB tries to search the referred tables in the front-end solidDB database.
启用了SQLpassthrough 后,当从应用程序执行一个 SQL查询时,solidDB试着在前端 solidDB数据库中搜索相关数据表。
If a SQL database is being deployed, MSDeploy will create a script of the schema and data, and allow the developer to include custom SQL scripts if necessary.
如果你已经部署了SQL数据库,那么MSDeploy就会创建包含schema和数据的脚本文件,并且允许开发者在必要时在其中包含自定义的SQL脚本。
This tutorial series teaches basic to advanced SQL and basic XQuery topics and shows how to express commonly asked business questions as database queries by using SQL queries or XQueries.
本系列教程为您讲解SQL的一些基础和高级话题以及XQuery的基础知识,并展示如何使用SQL查询或XQuery语句将常被问起的业务问题表达为数据库查询。
You learned how to interact with XML data in the DB2 database using SQL, SQL/XML and XQuery statements.
您学习了如何使用SQL 语句、SQL/XML和XQuery 语句与DB2数据库中的 XML数据交互。
Displays runtime SQL - MaintainJ captures the actual runtime SQL statements going to the database with parameters populated regardless of the JDBC framework used.
显示运行时sql——不管你使用的是哪种JDBC框架,MaintainJ都能够捕获到发送到数据库实际运行的SQL语句以及其中的参数。
After the table is created in the DB2 database, you use data Studio to create a SQL file containing the SQL statement.
在DB 2数据库中创建表之后,则可以使用DataStudio来创建包含sql语句的SQL文件。
If static SQL is executed in your monitored database and you want to collect the data into the report, check the check box Retrieve the text of static SQL statements.
如果在数据库中执行静态SQL,希望把它们的数据收集到报告中,那么选中复选框Retrieve thetextofstatic SQL statements。
At the moment the query is created, no SQL statement is issued to the database. The SQL statement is created and executed when your code iterates the IQueryable object.
当创建这个查询时,SQL语句并没有被发送到数据库中,只有当你在代码中对这个IQueryable对象进行Iterate操作时,这个SQL语句才会被创建并执行,这个概念就是延迟执行。
For the November CTP of SQL Server 2008, which came out a few weeks ago, we have released a patch which enables Visual Studio 2005 to connect to a SQL Server 2008 database.
几个星期前,在SQLServer 2008CTP11月版本中,我们发布了一个补丁,使得VisualStudio 2005能够连接到SQL Server 2008数据库。
应用推荐