22,300
社区成员
发帖
与我相关
我的任务
分享oracle 的 empty_clob() 转换成SQlServer 的怎么转 100结贴%
oracle 的 empty_clob() 转换成SQlServer 的怎么转
oracle
// 1.插入一行
String sql1 = "insert into nncredit_article " + "(classoid,title,content,source,remark," + "sort,use_state,record_user, record_create_time,";
sql1 += "record_modify_time,isshow,showimageurl,author,VERIFYSTATE,bytenum )" + " VALUES(" + bean.getClassoid() + "," + "'" + bean.getTitle() + "'," + "empty_clob()," + "'" + bean.getSource() + "'," + "'" + bean.getRemark() + "'," + "" + bean.getSort() + "," + "" + bean.getUser_State() + "," + "'" + bean.getRecord_User() + "',";
oracle
// 1.插入一行
String sql1 = "insert into nncredit_article " + "(classoid,title,content,source,remark," + "sort,use_state,record_user, record_create_time,";
sql1 += "record_modify_time,isshow,showimageurl,author,VERIFYSTATE,bytenum )" + " VALUES(" + bean.getClassoid() + "," + "'" + bean.getTitle() + "'," + "empty_clob()," + "'" + bean.getSource() + "'," + "'" + bean.getRemark() + "'," + "" + bean.getSort() + "," + "" + bean.getUser_State() + "," + "'" + bean.getRecord_User() + "',";
...全文
请发表友善的回复…
发表回复
qq_17071143 2015-03-25
- 打赏
- 举报
LongRui888 2015-03-25
- 打赏
- 举报
上面看错了：
oracle 中有blob类型，但是sql server 没有clob类型，只有 相应的 varchar(max)类型。
一般要写入大量数据，可以通过程序来写。
LongRui888 2015-03-25
- 打赏
- 举报
oracle 中有blob类型，但是sql server 没有blob类型，只有 相应的 varbinary类型。
qq_17071143 2015-03-25
- 打赏
- 举报
没有对应的 差不多一样的吗
还在加载中灬 2015-03-24
- 打赏
- 举报
我了解了下，貌似没有这个对应的函数，我想你可以直接设置为NULL
MSSQL和ORACLE更新LOB的方法也不太一样
