摘要:
怎样把_variant_t转换成字符窜型啊!cstring
......
摘要:
create function getfields (@tablename varchar(128),@curfield varchar(128),@curvalue varchar(128),@returnfields varchar(128)) returns varchar(1000) as begin declare @return_str varchar(1024) decl......
简单问题
在表中有一字段序号,为字符型值为01,02,03,04,05,06,07,08,09,10,11,12我用update department set departmentid=cstr(str(departmentid)-1) where str(departmentid) >6,执行后变成了1,2,3,4,5,6,6,7,8,9,10,11我想还是两位的字符怎么做?求代码?
NO.1 作者: yoki
update department
set departmentid=right("0"+cstr(str(departmentid)-1),2)
where str(departmentid) >6
摘要:
我写的checkbox是树状的,有三层,有求点击父后,父和父的子都打勾,再点击父则全部撤销!下面是程序,第一布已经实现! function icheselect() { var obj=document.all.check1; for(i=0;i<obj.length;i++){ if(obj[i].checked){ var idi=obj[i].value; var fid......