Home Forums SQL Server 2008 SQL Server 2008 - General Incrementing a column without seting Identity property RE: Incrementing a column without seting Identity property

  • September 11, 2012 at 3:11 am

    #1536069

    I have gt this idea suggest me if i can do it in a better way .........

    The much better way would be to contact DBA (if you cannot change it yourself) and advise that you need identity there. Dwain is absolutely right.

    Instead of implementing the square-weels bicycle you better use in-build feature of SQL Server designed exactly for the purpose.

    _____________________________________________
    "The only true wisdom is in knowing you know nothing"
    "O skol'ko nam otkrytiy chudnyh prevnosit microsofta duh!":-D
    (So many miracle inventions provided by MS to us...)

    How to post your question to get the best and quick help[/url]