You are creating a Microsoft Windows Mobilebased application by using the Microsoft .NET Framework 3.5 and Microsoft Synchronization Services for ADO.NET. The application connects to a Microsoft SQL Server 2005 database.
The application uses the SyncAdapter object. You set the InsertCommand command of the SyncAdapter object to a T-SQL statement.
You write the following T-SQL statement. (Line numbers are included for reference only.)
01 INSERT INTO dbo.DiscountType ([DiscountTypeID], [Name], [LastEditDate], [CreationDate]) VALUES (@DiscountTypeID, @Name, @LastEditDate, CreationDate)
02
When the SyncAdapter object executes the InsertCommand command, all the data inserts are identified as conflicts. You discover that these data inserts were synchronized correctly.
You need to ensure that the application can identify successful data inserts.
Which SQL statement should you insert at line 02?
A.
SET @sync_result = @@ERROR
B.
SET @sync_result = @@IDENTITY
C.
SET @sync_result = @@ROWCOUNT
D.
SET @sync_result = @@TOTAL_WRITE