1

Closed

When a table has only one row, that row is not uploaded on SQL Azure

description

As said in the title,
I got a database were one the table has only one row, and that row is not upload to SQL Azure.
As soon as I have a second row, the two of them are uploaded.
I tried it with a database with only one table, with the same problem.
Here is the sql script :
 
SET ANSI_NULLS ON
 
SET QUOTED_IDENTIFIER ON
 
IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[XYZ]') AND type in (N'U'))
BEGIN
CREATE TABLE [dbo].[XYZ](
[CCompanyId] [uniqueidentifier] NOT NULL,
[CNetwork] [uniqueidentifier] NOT NULL,
[COwner] [uniqueidentifier] NOT NULL,
[CName] [nvarchar](100) COLLATE French_CI_AS NOT NULL,
[CCajCustomer] [int] NULL,
[CCajSite] [int] NULL,
[CDbVersion] [nvarchar](20) COLLATE French_CI_AS NOT NULL,
[CFamilyStartLevel] [int] NOT NULL,
CONSTRAINT [PK_COMPANY_1] PRIMARY KEY CLUSTERED
(
[CCompanyId] ASC
)WITH (STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF)
)
END
 
Here is the row :
 
CCompanyId
00000000-0000-0000-0000-000000000000
CNetwork
00000000-0000-0000-0000-000000000000
COwner
00000000-0000-0000-0000-000000000000
CName
Abcde
CCajCustomer
NULL
CCajSite
NULL
CDbVersion
0.0.0.0
CFamilyStartLevel
1
 
Here the display :
Process starting ...
-- Success: CREATE TABLE [dbo].[XYZ]( ...
 
Uploading data to "PR_Test.dbo.XYZ
 
Processing finished
 
 
As you can see, there isn't the number of line uploaded.
Closed Jan 3, 2010 at 11:45 PM by ghuey

comments

ghuey wrote Dec 15, 2009 at 12:14 PM

Resolved. Changed line while (retry && start < end) to while (retry && start <= end). Will post in v3.1

Thanks!
George

clavelm wrote Dec 15, 2009 at 1:46 PM

Solved,
Thanks