数据量存储过程SQL语句
if(@type=‘UserControl_Loaded_SelectTravellerInformation’)
begin
SELECT
ROW_NUMBER() over(order by S_UserFile.userFileID desc)as number,
S_UserFile.userFileID,
S_UserFile.userID,
rtrim (S_UserFile.userName) as userName,
S_UserFile.dateOfBirth,
S_UserFile.theAge,
rtrim (S_UserFile.countryOrRegion)as countryOrRegion,
rtrim (S_UserFile.certificateNumber)as certificateNumber,
rtrim (S_UserFile.phoneNumber)as phoneNumber,
rtrim (S_UserFile.emergencyPhone)as emergencyPhone,
rtrim (S_UserFile.userAddres)as userAddres,
rtrim (S_UserFile.emergencyAddress)as emergencyAddress,
rtrim (S_UserFile.zipCode)as zipCode,
S_UserFile.registerDate,
S_UserFile.as_CertificateTypeID,
rtrim (D_DetailAttributeGather.detailedAttributeName) as AttributeName,
S_UserFile.as_PassengerTypeID,
rtrim (D_DetailAttributeGather_1.detailedAttributeName) AS PassengerType ,
Wpf单表查询
最新推荐文章于 2023-11-30 16:28:24 发布
![](https://img-home.csdnimg.cn/images/20240711042549.png)