用asp+sql语句动态的创建access表

<% nowtime = now()tablename = cstr(year(nowtime))+"_"+cstr(second(nowtime))response.write tablename  db_path = "test.mdb"Set conn= Server.CreateObject("ADODB.Conn…

用SQL语名合并列

合并A，B，C 3列变成如下

ABC

当A是数值,B,C均为字符时:

select rtrim(cast(A as varchar))+rtrim(B)+rtrim(C) from tableName