SQL查询，选择前100个元组怎么写的

oracle 数据是 select * from tablename where rownum<=100

sqlserver 数据库 select top 100 from tablename

mysql select * from table1 limit 100

老师不是说的很清楚吗？用函数！

CREATE FUNCTION dbo.f_str(@id int)

RETURNS varchar(8000)

AS

DECLARE @i int

DECLARE @name varchar(10) --姓名

DECLARE @villageCode varchar(20) --所属村代码

Set @i = 0

--开始循环插入数据:

WHILE @i <3000

BEGIN

Set @i =@i +1

SET @name = (select top 1 Name from ConstructionPlatformDB.dbo.BasePerson ORDER BY NEWID()) --随机取数据

set @villageCode = (select top 1 Code from Countrywide where len(code) = 12 ORDER BY NEWID())

insert into Operators(Name,VillageCode) values(@name,@villageCode)

END

String

sql_insert

=

"insert

into

client

(clientNo,clientName)

values(client_no,'

"+client_no+"

')"

中的：

client_no，你没有用变量，

其实后面的name你也错了，不过不影响语法

---