use db declare @order nvarchar(50) set @order = '订单号' select id as '订单号', bookingdate as '拍照预约', [time] as '预约时间', waiter1 as '摄影师', waiter2 as '化妆师', clerk as '录入人' from dindanjd where id = '@order'