sql判断且增加字段ADD

sql 判断且增加字段 % dim i,rs,sql,table,column,bool table = a column = b bool = false sql=select * from [table] set rs = conn.execute(sql) for each i in rs.fields 'response.write(i.namebr) if i.name=column then bool = true exit for end if

sql 判断且增加字段

<%
dim i,rs,sql,table,column,bool
table = "a"
column = "b"
bool = false
sql="select * from ["&table&"]"
set rs = conn.execute(sql)
for each i in rs.fields
'response.write(i.name&"
")
if i.name=column then
bool = true
exit for
end if
next
if bool then
response.write("在《"&table&"》表中,存在《"&column&"》列!")
else
response.write("在《"&table&"》表中,不存在《"&column&"》列!")
end if
%>

.syntaxhighlighter{padding-top:20px;padding-bottom:20px;}

【说明】：本文章由站长整理发布，文章内容不代表本站观点，如文中有侵权行为，请与本站客服联系(QQ:)！