Dont.top

Delphi7 DBGrid 自动调整列宽

Delphi Adjust Column width DBGrid procedure FitGrid(Grid: TDBGrid); const C_Add=3; var ds: TDataSet; bm: TBookmark;

group by (1) group by的含义:将查询结果按照1个或多个字段进行分组，字段值相同的为一组 (2) group by可用于单个字段分组，也可用于多个字段分组

select * from sysobjects where xtype='u' --查看数据库中的表信息 AVG(字段名) 平均值 COUNT(*|字段名) 行数统计 MAX(字段名) 取得一个表格栏最大的值 MIN(字段名) 取得一个表格栏最小的值

SELECT CASE WHEN col.colorder = 1 THEN obj.name ELSE '' END AS 表名, col.colorder AS 序号 , col.name AS 列名 , ISNULL(ep.[value], '') AS 列说明 ,

SELECT [TableName] = [Tables].name , [TableCreateDate] = [Tables].create_date , [TableModifyDate] = [Tables].modify_date FROM sys.tables AS [Tables]