I have a table Role in sql server with following columns:

RoleID numeric primary key

Name nvarchar Nullable

Description nvarchar Nullable

Creation Date datetime Nullable

When i drop this table in designer of datset in vs.net2005 and try to make a update query,it makes query like the one below.

UPDATE [dbo].[Role] SET [Name] = @Name, [Description] = @Description, [CreationDate] = @CreationDate WHERE (([RoleID] = @Original_RoleID) AND ((@IsNull_Name = 1 AND [Name] IS NULL) OR ([Name] = @Original_Name)) AND ((@IsNull_Description = 1 AND [Description] IS NULL) OR ([Description] = @Original_Description)) AND ((@IsNull_CreationDate = 1 AND [CreationDate] IS NULL) OR ([CreationDate] = @Original_CreationDate)));
SELECT RoleID, Name, Description, CreationDate FROM Role WHERE (RoleID = @RoleID)

Please let me know what is the use of firing select statement after update when optimistic concurrency is handled in update itself. And how the ouptut of Select statement is captured here

Thanks