Professional Web Applications Themes

IDENT CURRENT - Microsoft SQL / MS SQL Server

I have table with PK on 2 columns: ID and Date are columns for primary key. If there is only one column for PK, I can get the last PK with ident_current: select ident_current('tableName') How can I get the PK, if it's combined from 2 columns? Thank you for your answer, Simon...

  1. #1

    Default IDENT CURRENT

    I have table with PK on 2 columns:
    ID and Date are columns for primary key.

    If there is only one column for PK, I can get the last PK with
    ident_current:

    select ident_current('tableName')

    How can I get the PK, if it's combined from 2 columns?

    Thank you for your answer,
    Simon


    Simon Guest

  2. #2

    Default Re: IDENT CURRENT

    IDENT_CURRENT is not a function used to retrieve a primary key, it is a
    function used to retrieve the current identity value. IDENTITY is not
    necessarily PK, nor vice-versa! They are not the same thing...

    With a two-column primary key, how do you define "last"? Maybe you could
    show your table structure (including key definition), sample data (insert
    statements), and desired resultset.





    "Simon" <si> wrote in message
    news:3f27d809$s5.net... 


    Aaron Guest

  3. #3

    Default Re: IDENT CURRENT

    IDENT_CURRENT is applicable only on identity columns & is a function which
    return the last identity value generated. To retrive any other value along
    with other columns you have to roll out your own code, something along the
    lines of:

    SELECT idcol, dtcol
    FROM tbl
    WHERE idcol = IDENT_CURRENT('tbl') ;

    --
    - Anith
    ( Please reply to newsgroups only )


    Anith Guest

Similar Threads

  1. Replies: 3
    Last Post: March 9th, 05:19 PM
  2. [Auth] "ident" method and LDAP user accounts
    By Stephane in forum PostgreSQL / PGSQL
    Replies: 10
    Last Post: March 8th, 09:29 AM
  3. Ident authentication
    By Jarkko Elfving in forum PostgreSQL / PGSQL
    Replies: 9
    Last Post: March 5th, 01:21 AM
  4. Replies: 1
    Last Post: July 20th, 03:27 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139