summaryrefslogtreecommitdiff
path: root/tests/unit/Data/SqlMap/scripts/mssql/embed-param-test-init.sql
blob: f776b15890feceae77a2453e8e0496271f766e5c (plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
-- Technique for creating large sample test data from
-- http://www.sql-server-performance.com/jc_large_data_operations.asp

use [IBatisNet]

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[ManyRecordsTest]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[ManyRecordsTest]



-- Create Test table using storage table sample data
SELECT 
	[Many_FirstID], 
	[Many_SecondID], 
	[Many_ThirdID], 
	[Many_FourthID],  
	[Many_FifthID],  
	[Many_SequenceID],  
	[Many_DistributedID], 
	[Many_SampleCharValue],  
	[Many_SampleDecimal], 
	[Many_SampleMoney], 
	[Many_SampleDate], 
	[Many_SequenceDate]
INTO [dbo].[ManyRecordsTest]
FROM [dbo].[ManyRecords]



-- Create Test table indexes
CREATE INDEX [IDX_ManyRecordsTest_Seq] ON [dbo].[ManyRecordsTest] ([Many_SequenceID])  WITH SORT_IN_TEMPDB
CREATE INDEX [IDX_ManyRecordsTest_Dist] ON [dbo].[ManyRecordsTest] ([Many_DistributedID]) WITH SORT_IN_TEMPDB