How to prevent ADO from altering my SQL command text?
如何防止ADO从改变我的SQL命令文本？
Can I control the range of records in my SQL statement?
我可以在我的SQL语句的记录范围控制？
Now, set the My SQL version attribute to a typical version number, such as 5.1, and check the status information again.
现在，您可以将My SQLVersion属性设置为一个典型的版本号，例如5.1，并再次检查状态信息。
Question: How do I use this logger when I am also making modifications to the framework and using it from my SQL-PL stored procedures?
问题：如果我对这个框架进行了一些更改，并且将在自己的 SQL-PL 存储过程中使用这些更改，那么应该如何使用这个日志程序呢？
I want to thank my team for delivering nested data-change-operations - one of the most exciting SQL extensions of the last years.
我还想感谢我的团队，是我们的团队交付了嵌套数据更改操作——这是过去几年来最令人激动的SQL扩展之一。
I did not have to write a single line of SQL code, yet my application is backed by a relational database.
我不必写SQL代码，但我的应用程序由关系数据库支持的。
For my example, I chose a minimum estimate query runtime of 0 because I wanted to avoid collecting detail for non-query SQL statements.
对于我的例子，我选择minimumestimatequeryruntime，并将值设为0，因为我想避免收集非查询sql语句的详细信息。
In this case, I created an SQL instance pointing to a MySQL database running on my machine.
在这个例子中，我创建了SQL实例，指向在我机器上运行的MySQL数据库。
As it happens, there are several distinct possibilities. For my team, however, the quickest way to resolve the question and return developers to their daily work is to interpose SQL Relay.
碰巧，存在一些不同的可能性，然而，对于我的团队，解决问题并使开发人员返回到日常工作的最快速的方法就是使用SQL Relay。
So yes, you can put a SQL database on a bigger box to buy yourself more headroom. But this fails point #1 on my checklist for true scaling.
是的，你还是可以将SQL数据库搭在更强的服务器上，从而提供更大的空间，但是这的确违背了我提到的关于真正的可扩展性的第一条标准。
SQL Prompt: Intelligent code completion and layout for SQL Server. “Accelerates all my programming.”
SQLPrompt: SQL服务器智能代码填写和布局“为我所有的编程提速。”
Download my code at bottom of the article for loading the Type 4 JDBC driver for SQL Server.
下载本文底部的我的代码，用于加载用于SQLServer的Type4JDBC驱动程序。
And, although I don't show it here, I also configured my DB2 II environment to access data in local XML files, a local MySQL DBMS, and a remote Microsoft SQL Server DBMS.
而且，虽然这里没有显示，但我还是配置了我的DB 2II环境，以访问本地XML文件、本地MySQLDBMS以及远程MicrosoftSQLServer DBMS中的数据。
In order to introduce Magnus to SQL-land, I need to first define my relational tables, which (predictably) I'll call account and location. That's shown in Listing 1.
为了让Magnus程序使用SQL数据库，我需要首先定义我的关系表，(可以预测)它将调用account和location。
Let's now get to some concrete SQL tuning examples I have collected in my work and see how you can appy the tuning guidelines discussed above.
现在，让我们获得一些我在工作中收集的具体的sql调优示例，并看一看如何可以应用上面所讨论的这些调优指导原则。
My good friend and business partner jokes that he became a DBA because SQL hasn't changed in 35 years. This is, largely, true.
我的好朋友和商业伙伴开玩笑说他成为一个数据库管理员是因为SQL已经35年没有变化了，这大部分是真的。
What are my most frequently executed SQL statements?
执行频率最高的sql语句有哪些？
My hope is that this article arms SQL developers with the information they need to incorporate XML into applications.
希望本文提供的信息可以帮助SQL开发人员将XML 功能结合进应用程序中。
In my two previous columns, I wrote about unnecessary SQL and gave examples of SQL that is executed far too many times and SQL that should be replaced with newer, better-performing SQL.
在前面两个专栏中，谈到不必要的SQL，并给出了执行次数过多的SQL例子，以及应当由更新的、性能更优的SQL来替代的例子。
This is why I used the try-except block: I can catch my own SQL errors and respond to them if needed.
这就是我使用try - except块的原因：我可以捕捉自己的SQL错误，并根据需要进行响应。
ActiveScaffold will create SQL that searches all varchar columns for the model so that entering a term like "ham" will find my user record based on my last name.
ActiveScaffold会创建一条sql语句为模型搜索所有的varchar列，这样输入诸如“ham”之类的条件就可以找到基于姓氏的用户记录了。
XQuery looks like SQL and solves many of the SQL problems that cause me to run back to my bookshelf for answers.
XQuery看起来很像SQL，解决了很多我不得不从书架上翻找答案的问题。
The first one adds users in the registeredUsers group to the registered-users role in the context of my-sql-realm, defined in my-db-plan.xml.
第一个把registeredusers组中的用户添加到my - sql - realm上下文(在my - db - plan . xml中定义)中的registered -users角色。
The grouping features of regular expressions can be used to extract data from a string. My RegexGroup function provides that functionality to T-SQL
正则表达式的分组功能可用于从字符串中提取数据。
For a department-specific table, you can also use the department or company name as schema, of course. To create a table called PERSON in my schema, I have to execute the following SQL command.
当然，对于特定于部门的表，还可以使用部门或公司名作为模式。
This is working really well and I get a lot of hits off of my cache and many fewer SQL queries.
这是工作真的很好，我过我的缓存和少得多的SQL查询获得大量点击。
This is what I do and what I recommend to clients, and I'm always happy for an excuse to exercise my infrequently used Entity SQL chops.
这是我做什么，我推荐给客户端，和我总是快乐的行使我不经常使用的实体sQL排骨的借口。
NET data provider, in my case that of MS SQL server.
NET数据提供商管理的，在我的情况是MSSQL服务器。
I also like to keep the DB as' dumb 'as possible when using EF, since I'm using EF so my team wont need to maintain SQL code.
我也喜欢保持DB尽可能“哑”使用EF时，因为我使用EF所以我的团队不会需要维护SQL代码。
I also like to keep the DB as' dumb 'as possible when using EF, since I'm using EF so my team wont need to maintain SQL code.
我也喜欢保持DB尽可能“哑”使用EF时，因为我使用EF所以我的团队不会需要维护SQL代码。
应用推荐