ÇóÖúSQL ²åÈë - MS-SQL Server / Ó¦ÓÃʵÀý

Èç¹ûA±íÓÐ100¸ö×ֶΣ¬ÈçºÎ¸øÕâ±íÔö¼ÓÒ»Ìõ¼Ç¼¶¼ÊÇ1

---

SQL code:
DECLARE @sql VARCHAR(1000)
SELECT @sql= 'select 1'+REPLICATE(',1',99)
EXEC('insert [Table] '+@sql)

---

insert into A select 1,1,1,1,1,1,1.....

---

ÒýÓÃ

SQL code
DECLARE @sql VARCHAR(1000)
SELECT @sql= 'select 1'+REPLICATE(',1',99)
EXEC('insert [Table] '+@sql)

It is a good idea

---

ÒýÓà 1 Â¥ chuifengde µÄ»Ø¸´:

SQL code
DECLARE @sql VARCHAR(1000)
SELECT @sql= 'select 1'+REPLICATE(',1',99)
EXEC('insert [Table] '+@sql)

It is a good idea
[/Quote]