随机选择其中一列 --这里应该是行吧?select top 1 * from 表名 order by newid()
用了20分钟,终于真相大白: 1。如果是随机取一行,以上兄弟正解。 2。以下是随机取一列: DECLARE @myColumn VARCHAR(20) DECLARE @mySQL VARCHAR(512)SELECT TOP 1 @myColumn=name FROM ( SELECT a.name FROM syscolumns a INNER JOIN sysobjects d ON a.id=d.id WHERE d.name='your-table-name') AS a ORDER BY newid() SET @mySQL='SELECT '+@myColumn+' FROM your-table-name'EXEC(@mySQL)请给分,哈哈。
1。如果是随机取一行,以上兄弟正解。
2。以下是随机取一列:
DECLARE @myColumn VARCHAR(20)
DECLARE @mySQL VARCHAR(512)SELECT TOP 1 @myColumn=name FROM (
SELECT a.name FROM syscolumns a
INNER JOIN sysobjects d ON a.id=d.id
WHERE d.name='your-table-name') AS a
ORDER BY newid() SET @mySQL='SELECT '+@myColumn+' FROM your-table-name'EXEC(@mySQL)请给分,哈哈。