- 博客(4)
- 资源 (1)
- 收藏
- 关注
原创 How to get table metadata without sql-statement invoking
You may use the connection and table name (and column name) to retrieve the meta-data information from the database. E.g. /** *
2011-08-30 15:14:51 461
原创 Use ResultSet repeated (multiple times)
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
2011-08-30 15:12:16 495
转载 SQL Server 转义字符序列 like escape的使用方法
%:匹配零个及多个任意字符; _:与任意单字符匹配; []:匹配一个范围; [^]:排除一个范围 引用内容 Symbol Meaning like'5[%]' 5% like'[_]n'
2011-08-07 07:44:38 1204
转载 Escape single quotes and wild cards ‘%’ , ‘_’ in MS SQL
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
2011-08-07 07:09:11 673
空空如也
TA创建的收藏夹 TA关注的收藏夹
TA关注的人