Database Reference
In-Depth Information
[AddressLine2] [nvarchar](60) NULL,
[City] [nvarchar](30) NOT NULL,
[StateProvinceID] [int] NOT NULL,
[PostalCode] [nvarchar](15) NOT NULL,
[SpatialLocation] [geography] NULL,
[rowguid] uniqueidentifier ROWGUIDCOL NOT NULL CONSTRAINT [DF_
Address_rowguid] DEFAULT (NEWID()),
[ModifiedDate] [datetime] NOT NULL CONSTRAINT [DF_Address_
ModifiedDate] DEFAULT (GETDATE())
) ON [SECONDARY];
GO
CREATE TABLE [dbo].[BusinessEntity](
[BusinessEntityID] [int] IDENTITY (1, 1) NOT FOR REPLICATION
NOT NULL,
[rowguid] uniqueidentifier ROWGUIDCOL NOT NULL CONSTRAINT [DF_
BusinessEntity_rowguid] DEFAULT (NEWID()),
[ModifiedDate] [datetime] NOT NULL CONSTRAINT [DF_
BusinessEntity_ModifiedDate] DEFAULT (GETDATE())
) ON [TERTIARY];
GO
PRINT '';
PRINT '*** Loading Data';
GO
PRINT 'Loading [dbo].[Address]';
BULK INSERT [dbo].[Address] FROM 'D:\SampleDbz\
AdventureWorks2008R2-Samples\AdventureWorks 2008R2 OLTP\Address.
csv'
WITH (
CHECK_CONSTRAINTS,
CODEPAGE='ACP',
DATAFILETYPE = 'widechar',
FIELDTERMINATOR= '\t',
ROWTERMINATOR = '\n',
KEEPIDENTITY,
TABLOCK
);
PRINT 'Loading [dbo].[BusinessEntity]';
 
Search WWH ::




Custom Search