Forum Replies Created

Viewing 15 posts - 4,741 through 4,755 (of 7,636 total)

  • RE: IDENTITY KEY

    Well I tried it and it does indeed work. Neat trick!

    November 27, 2008 at 12:20 pm

    #904460

  • RE: IDENTITY KEY

    shmuel_v (11/27/2008)

    1. rbarryyoung ,

    There is no need to have a partition table to execute a switch between 2 tables.

    Hmm, that's odd then, because according to BOL one...

    November 27, 2008 at 12:11 pm

    #904457

  • RE: IDENTITY KEY

    Gouthama Kolivad (11/27/2008)

    Just set the column as identity... set auto increment by 1...

    and starting from 50000001(which no. u want to start from ).

    It should not effect anything.. unless you have...

    November 27, 2008 at 12:07 pm

    #904456

  • RE: IDENTITY KEY

    The only "easy" way to do this that I know of is to use Management Studio to do it in the Table Designer. Although this seems like it is...

    November 27, 2008 at 11:57 am

    #904452

  • RE: IDENTITY KEY

    steveb (11/27/2008)

    shmuel_v (11/27/2008)

    Hi,

    First, you can't change the column to identity.

    Why not? do you have any proof of this..?

    The ALTER TABLE ... ALTER COLUMN statement has no option to...

    November 27, 2008 at 11:51 am

    #904450

  • RE: IDENTITY KEY

    shmuel_v (11/27/2008)

    -- I switch between the old table to the new table.

    ALTER TABLE TABLE1 SWITCH TO NEW_TABLE1

    I believe that SWITCH requires either the source table or the target table to...

    November 27, 2008 at 11:47 am

    #904447

  • RE: Functio to get Amount in words.

    Man, you write nice code, Chris. I always enjoy reading it.

    November 27, 2008 at 11:08 am

    #904438

  • RE: Create Table so that user is the owner

    J (11/27/2008)

    Could you not just use a common table with an extra field like "OwnerID"to keep the data separate for each user and query with a [font="Courier New"]SELECT FROM...

    November 27, 2008 at 11:03 am

    #904437

  • RE: user,role, and login namespaces

    The problem with using that DMO code (or any DMO code) to script out a 2005 database, is that it will miss everything that is new with 2005. For...

    November 27, 2008 at 10:54 am

    #904433

  • RE: Batch Processing

    *sigh*

    Again, this statement:

    I have to update these databases in another database name"DateAgain".

    makes no sense. You cannot "Update" one database to another (or "on" another, or "in" another, etc.)....

    November 27, 2008 at 10:44 am

    #904431

  • RE: Linking a Notes table to multiple tables

    dan: The question to be answered is "what is the real value of having all of these notes attached to different things collected into the same table?" I...

    November 27, 2008 at 10:32 am

    #904425

  • RE: dateAdd inside where clause

    Vladan (11/27/2008)

    rbarryyoung (11/25/2008)

    I think that Vladan's "-7" should probably be "+7", but I am not sure

    That depends whether you need data from the last 7 days (like if you need...

    November 27, 2008 at 10:03 am

    #904411

  • RE: Functio to get Amount in words.

    Chris Morris (11/27/2008)Dunno if it's restrictions on the work pc's here but the sig editor has a mind of it's own.

    I hear that. It took me forever to get...

    November 27, 2008 at 9:46 am

    #904404

  • RE: Batch Processing

    Hmm, that's an angle I hadn't thought of. Still, I'd like some clarification from the OP.

    November 26, 2008 at 9:43 pm

    #904132

  • RE: Batch Processing

    Specifically, you need to explain what "i need to update {0} to another database' means, because it makes no sense.

    November 26, 2008 at 7:50 pm

    #904112

Viewing 15 posts - 4,741 through 4,755 (of 7,636 total)