帮助sql语句 [英] help with sql statement
本文介绍了帮助sql语句的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
hi
是否可以在datagridview中加载表并在另一个datagridview中打开所选表,就像使用combobox打开选定的表一样?我得到了sql语句,在sql server compact中显示了包含其他模式信息的表的列表。我想用ms访问数据库尝试它。
任何帮助将不胜感激
hi
Is it possible to load tables in datagridview and open selected table in another datagridview just like opening a selected table using combobox? I got the sql statement that displays list of tables with other schema information in sql server compact.I want to try it with ms access database .
any help would be appreciated
Dim Query2 As String = " Select * from INFORMATION_SCHEMA.TABLES WHERE TABLE_TYPE = 'TABLE'"
推荐答案
是.. 。
从INFORMATION_SCHEMA.TABLES中选择*其中table_name类似于''E%''
Yes ...
Select * from INFORMATION_SCHEMA.TABLES where table_name like ''E%''
感谢您快速回复。我会尝试一下
Thank you for quick response .I will try it out
这篇关于帮助sql语句的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
查看全文