DECLARE @a NVARCHAR(20)
SELECT @a='cCusName'
exec ('SELECT '+@a+',fMoney FROM SaleBill')SELECT @a='dDate'
exec ('SELECT '+@a+',fMoney FROM SaleBill')
SELECT @a='cCusName'
exec ('SELECT '+@a+',fMoney FROM SaleBill')SELECT @a='dDate'
exec ('SELECT '+@a+',fMoney FROM SaleBill')
想要进行动态列的查询,要使用exec来执行。