How to insert multiple rows of data in SQL Server 2008 R2

When you insert multiple rows of data, you do not have to write more than n insert INTO.

SELECT DISTINCT ' (' + ' "' +loginip + ' + ') ' + ', ' from dbo. Login

WHERE LoginName in

(

SELECT DISTINCT loginname from dbo. Login

WHERE loginip= ' 61.170.245.61 '

)

Go

--to obtain such a result

(' 61.61.245.243 '),

(' 61.61.245.61 '),

So direct

INSERT INTO Testip values

(' 1.192.47.125 '),

(' 1.58.113.154 '),

(' 1.85.189.111 '),

(' 1.86.37.156 '),

(' 101.84.100.87 '),

(' 106.83.49.191 ') high efficiency!

See more highlights of this column: http://www.bianceng.cnhttp://www.bianceng.cn/database/SQLServer/