acuna1的专栏

<br />There are few ways to do it.  <br /> <br />1. The first way is to start up profiler<br />or set up server side trace and filter the textdata column with the<br />table's name.  This way you'll see all activities on the table<br />including select sta

Create a table unless it already existsTo create a table in SQL Server, unless it has already been created:if not exists (select * f

%：匹配零个及多个任意字符； _：与任意单字符匹配； []：匹配一个范围； [^]：排除一个范围  引用内容Symbol               Meaning like'5[%]'           5% like'[_]n'

To escape single quotes ( ‘ ) in MS SQL all you need to do is add two single quotes instead of one.Ex. If you want to insert the name D’so

For the accessing of ResultSet is through cursor by using next() or previous, so as a matter of fact,  the cursor of database is moving.  To

You may use the connection and table name (and column name) to retrieve the meta-data information from the database. E.g.  /**   *

SQL JOIN 有些模糊了，今天用到再温习一下：）------------------------------------------------------------------- 联接类型        在关系代数中，联接运算是由一个笛卡尔积运算和一个选取运算构成的。首先用笛卡尔积完成对两个数据集合的乘运算，然后对生成的结果集合进行选取运算，确保只把分别来自两个数据集合并且