--随机取一条 select top 1 * from table order by newid()
如果该表有主键:select * from tablename where 主键=xxxx如果该表没有主键,并且随意选择:select top 1 * from tablename order by newid()如果该表没有主键,但是想选择确定记录:alter table tablename add [id] int identity(1,1) go select * from tablename where [id]=xxxx
WHERE 字段名=???
有这样的写法的阿
select top 1 * from table order by newid()
go
select * from tablename where [id]=xxxx