摘要: 常见的情况为:插入的值大于字段定义的最大长度.String or binary data would be truncated. The statement has been terminated 阅读全文
posted @ 2013-07-28 19:06 wonkju 阅读(472) 评论(0) 推荐(0) 编辑
摘要: 一、 试验归类测试SQL:drop table acreate table a(a varchar(2))insert into a values('a')insert into a values(N'a')insert into a values('深圳')insert into a values... 阅读全文
posted @ 2013-07-28 18:54 wonkju 阅读(1382) 评论(0) 推荐(0) 编辑
摘要: 如我的提问:http://bbs.csdn.net/topics/390496351?page=1#post-394837834拥有类原子功能的类:class ShareState { //原子功能. private object _shareState = new object()... 阅读全文
posted @ 2013-07-28 02:24 wonkju 阅读(388) 评论(0) 推荐(0) 编辑
摘要: 注意:下面的举例适用于ORCLE和MSSQL,不能在Access中使用。语法SELECT COUNT(DISTINCT column(s)) FROM table举例With this "Orders" Table:用的是这张"Orders"表:CompanyOrderNumberSega3412W... 阅读全文
posted @ 2013-07-28 02:17 wonkju 阅读(3612) 评论(0) 推荐(0) 编辑
摘要: 存储过程的SQL代码:ALTER PROCEDURE USP_DBBackup @BackPath nvarchar(100), --存储目录. @BackName nvarchar(50) --存储数据库名.AS SET NOCOUNT ON dec... 阅读全文
posted @ 2013-07-28 01:37 wonkju 阅读(325) 评论(0) 推荐(0) 编辑