Post reply

SEQUENCE of A-101,A102

  • February 17, 2012 at 12:58 am

    #268450

    I am using MSSQL 2008

    I am tried for below ,

    where primary key should be in A101,A102

    Order No Date Product Qty Customer Batch No

    A101 10-Oct-2010 Mac Book 03 John B01

    A102 10-Oct-2010 I-Phone 05 Smith B02

    A103 10-Oct-2010 I-Pad 10 Kallis B03

    A101 10-Oct-2010 Mac Book 02 John B04

    A102 10-Oct-2010 I-Phone 07 Smith B05

    A103 10-Oct-2010 I-Pad 15 Kallis B06

    is there any property there which remained disable????

    please reply

    Thanks & Regards,
    Pallavi

  • February 17, 2012 at 3:51 am

    #1448386

    Replying...

    Sorry mate, cannot understand your question at all. Which property are you looking for?

    _____________________________________________
    "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]

  • February 17, 2012 at 4:55 am

    #1448400

    Please read the articles about asking questions in my signature.

    Order number can't be the primary key, as the column doesn't contain only unique values.

    Need an answer? No, you need a question
    My blog at https://sqlkover.com.
    MCSE Business Intelligence - Microsoft Data Platform MVP

  • February 17, 2012 at 6:13 am

    #1448441

    pallavi.unde (2/17/2012)

    I am using MSSQL 2008

    I am tried for below ,

    where primary key should be in A101,A102

    Order No Date Product Qty Customer Batch No

    A101 10-Oct-2010 Mac Book 03 John B01

    A102 10-Oct-2010 I-Phone 05 Smith B02

    A103 10-Oct-2010 I-Pad 10 Kallis B03

    A101 10-Oct-2010 Mac Book 02 John B04

    A102 10-Oct-2010 I-Phone 07 Smith B05

    A103 10-Oct-2010 I-Pad 15 Kallis B06

    is there any property there which remained disable????

    please reply

    As Koen said, in the sample data given by you OrderNumber can't be the Primary Key as Primary Key column's data should be unique. Or may be you are trying to ask something else.

    Sujeet Singh

Viewing 4 posts - 1 through 3 (of 3 total)

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