SQL 向表B添加5个随机生成的字母组合记录，求语句！

显示全部楼层 · 2011-3-5 03:16:09

DECLARE @count INTEGER
DECLARE @index INTEGER
declare @sql nvarchar(400)
declare @un nvarchar(400)
select
@sql= \'select char( \' cONVERT(NVARCHAR,CONVERT(INT,26*rand()) 97)\')
CHAR( \' CONVERT(NVARCHAR,CONVERT(INT,rand()*26) 97)\')
CHAR( \' CONVERT(NVARCHAR,CONVERT(INT,rand()*26) 97)\')
CHAR( \' CONVERT(NVARCHAR,CONVERT(INT,rand()*26) 97)\')
CHAR( \' CONVERT(NVARCHAR,CONVERT(INT,rand()*26) 97)\')
CHAR( \' CONVERT(NVARCHAR,CONVERT(INT,rand()*26) 97)\')
CHAR( \' CONVERT(NVARCHAR,CONVERT(INT,rand()*26) 97)\') \'

SET @count=5
SET @index=1

WHILE @index@count
BEGIN

EXEC(@sql)
INSERT INTO B(u1)
VALUES (@sql)

SET @index=@index 1
END
GO

这个试过了，把select语句给添加进去了

千问 · 2011-3-5 03:16:09

<pre id=\"best-answer-content\" class=\"reply-text mb10\">DECLARE @count INTEGER
DECLARE @index INTEGER
declare @sql nvarchar(400)
declare @un nvarchar(400)
set @sql= \'insert into B(u1) select CHAR( \' CONVERT(NVARCHAR,CONVERT(INT,26*rand()) 97)\')
CHAR( \' CONVERT(NVARCHAR,CONVERT(INT,rand()*26) 97)\')
CHAR( \' CONVERT(NVARCHAR,CONVERT(INT,rand()*26) 97)\')
CHAR( \' CONVERT(NVARCHAR,CONVERT(INT,rand()*26) 97)\')
CHAR( \' CONVERT(NVARCHAR,CONVERT(INT,rand()*26) 97)\')
CHAR( \' CONVERT(NVARCHAR,CONVERT(INT,rand()*26) 97)\')
CHAR( \' CONVERT(NVARCHAR,CONVERT(INT,rand()*26) 97)\') \'

SET @count=5
SET @index=1

WHILE @index@count
BEGIN
EXEC(@sql)
SET @index=@index 1
END
GO