This information could be helpful to an experienced SQL developer.
该信息对有经验的SQL开发人员有所帮助。
This can be useful in those critical situations where you need to at least temporarily fix an urgent SQL problem but cannot wait for a fix from a vendor or developer.
这种方法对于一些关键情况很有用,在那些情况下,您至少需要修复一个紧急SQL问题,但等不及供应商或开发人员提供修复程序。
Using this approach both the developer and tester can find the offending SQL statements and finish the first step of the concurrency performance problem resolution.
使用该方法,开发人员和测试人员都可以发现不良sql语句,并完成并发性能问题解决方案的第一步。
It appeared to us that a managed persistence solution was not required for our programming model, and we wanted to unleash the power of SQL without hiding it from the developer.
显然,对于我们的编程模型,受管持久性解决方案不是必需的,我们希望释放出SQL的威力,而不是对开发人员隐藏它。
Note: This article assumes that you're an application developer or DBA, who is already familiar with writing SQL stored procedures.
注意:本文假设您是应用程序开发人员或DBA,而且已经熟悉如何编写SQL存储过程。
Three-tier architectures and popular frameworks make this isolation more difficult, because the developer might never see the SQL generated by the framework.
层架构和流行的框架让隔离过程更加困难,因为开发人员可能永远不能看到框架生成的SQL 语句。
In addition to the overflow exploits, SQL injection is one other type of attack that relies on developer oversight by not testing incoming data.
除了溢出的利用以外,SQL注入是另一类依赖于开发人员没测试输入数据的疏漏的攻击。
This is the SQL procedure tracing API as used by an application developer.
也就是从应用程序开发人员用来跟踪api的SQL过程开始。
The developer can now improve the SQL (or work with the DBA to do so) and repeat the cycle until the SQL USES a desired access path.
现在,开发人员能够改进SQL(或与DBA合作完成)并重复此周期,直到SQL使用了期望的访问路径。
It means that when an SQL statement is going to be executed more than once, the developer should prepare the statement just once and then reuse the prepared statements for consecutive executions.
就是说如果sql语句要执行多次,开发人员应该只准备该语句一次,在以后的执行中重用准备好的语句。
Like SQL, parallelization is handled by the language itself without effort by the developer.
类似对SQL的处理一样,并行的版本通过语言本身来处理,而无需开发人员的努力。
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脚本。
We have heard stories about DBAs walking the halls, SQL printout in hand, asking each developer, "Is this your query?"
我们经常看到这样的场景,DBA 在大厅里拿着打印出的SQL 语句,询问每个开发人员:“这是您的查询吗?”
For example, using SQL to create a multi-table outer join that outputs its results to a new XML document is much more complicated to the average developer than writing XQuery.
比方说,对于一般开发人员,使用SQL创建输出结果为新xml文档的多表外连接查询要比编写XQuery复杂得多。
If a less-than-careful developer entered the text from Listing 5 (in the hopes of embedding the values directly), the call would be exposed to SQL injection attacks.
如果一位粗心大意的开发人员输入了清单5中的文本(以便直接嵌入值),这个调用将面临SQL注入攻击的风险。
SQLServer 2008开发者版.
The ability to have all the SQL issued from the application readily available to the developers empowers the developer in many scenarios as described in the next few sections.
这使从应用程序发出的所有SQL都能够被开发人员使用,从而增强了许多场景中的开发人员的能力。以下几节将对此进行描述。
Because the developers chose JDBC or a JDBC-based framework, the DBA had limited tools to help the developer know what applications the SQL was coming from.
因为开发人员选择JDBC或基于JDBC的框架,所以dba只能使用有限的工具来帮助开发人员了解SQL来自哪个应用程序。
For example, a developer who is going to create a feed from a relational database needs to have at least a rudimentary knowledge of database schemas and SQL.
例如,打算从关系数据库创建提要的开发人员至少需要对数据库模式和SQL拥有基本的了解。
SQL Server 2008 developer allows developers to build and test any type of application with SQL Server.
SQLServer 2008开发者版允许开发人员构建和测试基于SQL Server的任意类型应用。
Data Studio developer gives more control and feedback to the developers and DBAs on static SQL development and the bind process, from design to bind.
DataStudioDeveloper向静态SQL开发和绑定过程中的开发人员和DBA提供了从设计到绑定的更多控制和反馈。
With Data Studio Developer, you can preview the packages in design mode to ensure that it has the right name, the correct SQL, and so on.
使用DataStudioDeveloper,您能够在设计模式中预览包,以确保它拥有恰当的名称、正确的SQL 等等。
Application Developer includes wizards which generate resource collection code for SQL databases and LDAP directories.
Application Developer包括了用于为SQL数据库和LDAP目录生成资源集合代码的向导。
Note that the IBM Data Studio Developer tool offers a debugger and an SQL profiler component that can be used to analyze execution of SQL PL procedures.
注意,IBMDataStudioDeveloper工具提供了一个调试器和一个SQL分析器组件,可以用于分析SQLPL过程的执行。
Data Studio Developer 1.1 supported many JDBC best practices such as executing SQL statements in batch.
DataStudioDeveloper 1.1支持许多最佳实践,比如批量执行sql语句。
Data Studio Developer 1.2 now makes static SQL development and deployment easier even for more complex scenarios. Some of the key new features include.
DataStudioDeveloper 1.2现在使在更加复杂的场景中开发和部署静态SQL变得十分轻松。
Data Studio Developer 1.2 now makes static SQL development and deployment easier even for more complex scenarios. Some of the key new features include.
DataStudioDeveloper 1.2现在使在更加复杂的场景中开发和部署静态SQL变得十分轻松。
应用推荐