查询操作

--根据条件查询主表和子表相应的数据，包括子表中的为空的主键
Select A.ReqNo as 申请编号,A.Name as 姓名,A.Nation as 民族,A.Sex as 性别,A.Birthday as 出生日期,A.Health as 健康状况,B.RPRstatus as 户口状况,B.RPRadds as 户口地址,IsGymPupil as 是否体育生
  From IntoSch_ReqBaseInfo A left Join IntoSch_ReqRPRInfo B ON A.ReqNo = B.ReqNo Where A.sex = 1

--查询字段的描述信息（扩展属性）
SELECT   *
FROM   ::fn_listextendedproperty (NULL, 'user', 'dbo', 'table', 't_intosch_baseinfo', 'column', default)