Post reply

plz explain the concept of newid() and rowguidgrid in create table command

  • December 28, 2006 at 11:10 pm

    #153359

    plz explain the concept of newid() and rowguidgrid in create table command

  • December 29, 2006 at 11:14 am

    #680556

    newid() is a function that returns a uniqueidentifier.

     

    rowguid is a setting that you can place on a uniqueidentifier datatype column to allow it to be used for replication.  All tables that are used in replication must have a rowguid.

  • December 30, 2006 at 9:10 pm

    #680633

    thanx a lot....

    can plz send me a example for it.

  • December 31, 2006 at 12:52 am

    #680636

    Only merge replication and transactional replication with immediate updating subscribers will have rowguid not all replicated tables...

     

    MohammedU
    Microsoft SQL Server MVP

  • December 31, 2006 at 12:59 am

    #680637

    Create Table Test

    ( Col1 int, rowguid uniqueidentifier  default newid() not null

     

    MohammedU
    Microsoft SQL Server MVP

  • January 1, 2007 at 9:54 am

    #680666

    RowGUID are not only for replication, though they are required for replication.

    ADO.Net and ADO also use RowGuid (if it is set on a table) for identifying rows for disconnected batch updates.  This generates much more efficient update queries. 



    Mark

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply