sqlconcept.com

‘How to generate data in SQL Server’ is a very interesting question, since there is not only one correct answer. It really depends on what the purpose is.

I talked to Pinal Dave (blog: SQLAuthority.com) earlier, and he suggested the following script:

?Download download.txt1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
USE tempdb
GO
— Create Table OneIndex with few columns
CREATE TABLE OneIndex (ID INT,
FirstName VARCHAR(100),
LastName VARCHAR(100),
City VARCHAR(100))

Continue reading […] How to generate data in SQL Server […]