常用SQL

Posted on 2011-06-09 11:35  kacoro  阅读(108)  评论(0)  编辑  收藏  举报
  1. 插入海量数据
use list
Go

declare @n int
set @n = 0
while @n<100000
BEGIN
Insert Into tb_Book(BookName,BookIntroduce,Author,Publish,PublishDate,BookImage,Price,Discount,refinement)
Values('图书名','图书简介','清华','清华大学出版社','2011-06-06','~\images\ftp\1.bmp','100','7.5','8')
Select @n = @n+1
END