摘要：declare @strSQL varchar(8000)declare @week decimal(18,0)declare @week1 decimal(18,0)set @week=(select week fromaaaa where date=convert(varchar(10),getdate(),112))set @week1=@week-1set @strSQL=''set @strSQL=@strSQL+'if object_id(''tempdb..#a'') is not null drop table #a cr 阅读全文

摘要：strSql = ""strSql = strSql & " select max(number) from dbo.#DATA" & vbCrLfrss.Open strSql, cnn numb = rss.Fields(0)rss.Close 阅读全文

摘要：aaa = Sheet1.Cells(i, 8).Value 变量赋值。bbb = Mid(aaa, InStrRev(aaa, ")", -1) + 5, 100) 截取")“ 这个字符后到第100位的字符ddd = UBound(Split(bbb, " ")) 计算空格出现的次数 bbb变量 空格注意是否是英文的还是中文的eee=Instr(strText, "a") 求strText这个字符串中a出现的次数select right(Rep,charindex(';',R 阅读全文