"André" <an@dre.ty> wrote in message
news:uST9WQhaHHA.208@TK2MSFTNGP05.phx.gbl...
> Hi,
>
> I use Visual Web Developper for my asp.net application. I defined a field
> in a table as UniqueIdentifier.
> In the database environment of VWD, i can see for that field:
>
> datatype: uniqueidentifier
> default value or bindings: (newid()) (or xxxxx-xxxx-xxx etc.. in
> hexadecimal form).
> rowguid: yes/no
>
> I tried several combinations of Default Value and RowGuid, but still don't
> understand very good what those options are doing.
> I couldn't find a clear explanation elsewhere.
>
> Thanks for help
> André
>
>

> André,
>
> Default value is the value inserted in the column if no value was
> specified by the insert statement. Newid is a funtion that creates a new
> uniqueidentifier. RowGuid tells SQL Server that this column uniquely
> identifies the row in the table - the RowGuid attribute is most often used
> by Replication.
>
> -- Bill
>
>
> "André" <an@dre.ty> wrote in message
> news:uST9WQhaHHA.208@TK2MSFTNGP05.phx.gbl...
>> Hi,
>>
>> I use Visual Web Developper for my asp.net application. I defined a field
>> in a table as UniqueIdentifier.
>> In the database environment of VWD, i can see for that field:
>>
>> datatype: uniqueidentifier
>> default value or bindings: (newid()) (or xxxxx-xxxx-xxx etc.. in
>> hexadecimal form).
>> rowguid: yes/no
>>
>> I tried several combinations of Default Value and RowGuid, but still
>> don't understand very good what those options are doing.
>> I couldn't find a clear explanation elsewhere.
>>
>> Thanks for help
>> André
>>
>>
>
>