应该与数据库引擎有关,在 Access 下,似乎是(以前做过,记忆模糊):select * from F1=**
用一个存储过程查询返回这个字段的名称,然后在VB里用这个输出参数构造查询语句,大体写一下 declare @FN as varchar(30) select @FN =[name] from syscolumns where id =(select id from sysobjects where [name]='testcust' and type='U') and colid=1 return @FN select * from testcust where " & cmd.Parameters("@t").Value & "=第一个字段的值
select * from tablename where field1name like "something"
select * from 表 where 第一列=**
select * from 表名 where 列名=**
select 第一列 from 表名 不知道第一列的话可以用 select name from syscolumns where id =(select id from sysobjects where name= 表名 and type ='U') and colid=1 查询出第一列
选择:select * from table1 where 范围 插入:insert into table1(field1,field2) values(value1,value2) 删除:delete from table1 where 范围 更新:update table1 set field1=value1 where 范围 查找:select * from table1 where field1 like ’%value1%’ ---like的语法很精妙,查资料! 排序:select * from table1 order by field1,field2 [desc] 总数:select count as totalcount from table1 求和:select sum(field1) as sumvalue from table1 平均:select avg(field1) as avgvalue from table1 最大:select max(field1) as maxvalue from table1 最小:select min(field1) as minvalue from table1
应该与数据库引擎有关,在 Access 下,似乎是(以前做过,记忆模糊):select * from F1=**
declare @FN as varchar(30)
select @FN =[name] from syscolumns where id =(select id from sysobjects where [name]='testcust' and type='U') and colid=1
return @FN
select * from testcust where " & cmd.Parameters("@t").Value & "=第一个字段的值
不知道第一列的话可以用
select name from syscolumns where id =(select id from sysobjects where name= 表名 and type ='U') and colid=1
查询出第一列
插入:insert into table1(field1,field2) values(value1,value2)
删除:delete from table1 where 范围
更新:update table1 set field1=value1 where 范围
查找:select * from table1 where field1 like ’%value1%’ ---like的语法很精妙,查资料!
排序:select * from table1 order by field1,field2 [desc]
总数:select count as totalcount from table1
求和:select sum(field1) as sumvalue from table1
平均:select avg(field1) as avgvalue from table1
最大:select max(field1) as maxvalue from table1
最小:select min(field1) as minvalue from table1
select X from Y