2 Passenger表中50条记录字段为pid pname sex cardnum phone username所属用户username从A1~A5中随机选中 需要SQL语句

以下是一种可能的SQL语句示例：

SELECT TOP 50
    ROW_NUMBER() OVER (ORDER BY NEWID()) AS pid,
    CONCAT('Passenger', ROW_NUMBER() OVER (ORDER BY NEWID())) AS pname,
    CASE WHEN ABS(CHECKSUM(NEWID())) % 2 = 0 THEN 'Male' ELSE 'Female' END AS sex,
    ABS(CAST(NEWID() AS INT)) AS cardnum,
    ABS(CAST(NEWID() AS INT)) AS phone,
    CONCAT('A', ABS(CHECKSUM(NEWID())) % 5 + 1) AS username
FROM
    sys.objects AS o1
CROSS JOIN
    sys.objects AS o2

这个SQL语句使用ROW_NUMBER()和NEWID()函数来生成递增的pid和随机的pname、sex、cardnum、phone和username。其中，sex字段根据随机数的奇偶性来确定，cardnum和phone字段使用ABS(CAST(NEWID() AS INT))生成随机数字，而username字段使用ABS(CHECKSUM(NEWID())) % 5 + 1生成随机的A1到A5之间的值