Alter Column

  • Comments posted to this topic are about the item Alter Column

  • Good one, thanks.

    ---------------------------------------------------
    "Thare are only 10 types of people in the world:
    Those who understand binary, and those who don't."

  • Interesting question, thanks.

    For people who like an official reference:

    ALTER TABLE (Transact-SQL)

    ALTER COLUMN

    Specifies that the named column is to be changed or altered.

    The modified column cannot be any one of the following:

    * ...

    * A computed column or used in a computed column.

    * ...

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

  • shanjan.sapra (4/29/2014)


    Comments posted to this topic are about the item <A HREF="/questions/computed+columns/109643/">Alter Column</A>

    nice question.

    --rhythmk
    ------------------------------------------------------------------
    To post your question use below link

    https://www.sqlservercentral.com/articles/forum-etiquette-how-to-post-datacode-on-a-forum-to-get-the-best-help
    đŸ™‚

  • Nice question

    I need to read again the rules about the ALTER TABLE

  • Koen, that really gives the answer away, you don't even need Google :ermm:


    On two occasions I have been asked, "Pray, Mr. Babbage, if you put into the machine wrong figures, will the right answers come out?" ... I am not able rightly to apprehend the kind of confusion of ideas that could provoke such a question.
    —Charles Babbage, Passages from the Life of a Philosopher

    How to post a question to get the most help http://www.sqlservercentral.com/articles/Best+Practices/61537

  • BWFC (4/30/2014)


    Koen, that really gives the answer away, you don't even need Google :ermm:

    Your point being?

    Normally you only see this thread after you answered the question.

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

  • Koen Verbeeck (4/30/2014)


    BWFC (4/30/2014)


    Koen, that really gives the answer away, you don't even need Google :ermm:

    Your point being?

    Normally you only see this thread after you answered the question.

    There's a Discuss link under the question on the homepage. It brings you straight to the discussion without having to answer the question. It may have been used in the past as a possible source of clues... Although not necessarily to the answer I hasten to add, more the interpretation of the question.


    On two occasions I have been asked, "Pray, Mr. Babbage, if you put into the machine wrong figures, will the right answers come out?" ... I am not able rightly to apprehend the kind of confusion of ideas that could provoke such a question.
    —Charles Babbage, Passages from the Life of a Philosopher

    How to post a question to get the most help http://www.sqlservercentral.com/articles/Best+Practices/61537

  • BWFC (4/30/2014)


    Koen Verbeeck (4/30/2014)


    BWFC (4/30/2014)


    Koen, that really gives the answer away, you don't even need Google :ermm:

    Your point being?

    Normally you only see this thread after you answered the question.

    There's a Discuss link under the question on the homepage. It brings you straight to the discussion without having to answer the question. It may have been used in the past as a possible source of clues... Although not necessarily to the answer I hasten to add, more the interpretation of the question.

    Never noticed the discuss link, good that you mention it.

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

  • Koen Verbeeck (4/30/2014)


    BWFC (4/30/2014)


    Koen Verbeeck (4/30/2014)


    BWFC (4/30/2014)


    Koen, that really gives the answer away, you don't even need Google :ermm:

    Your point being?

    Normally you only see this thread after you answered the question.

    There's a Discuss link under the question on the homepage. It brings you straight to the discussion without having to answer the question. It may have been used in the past as a possible source of clues... Although not necessarily to the answer I hasten to add, more the interpretation of the question.

    Never noticed the discuss link, good that you mention it.

    It certainly has its uses but I'm always careful what I post because unscrupulous types could use it to bypass the hours of research that I may have been through. As I said, if the meaning of the question isn't always clear it's a useful place to get hints as to what the intention may have been. To be honest I don't think a lot of people know it's there though.


    On two occasions I have been asked, "Pray, Mr. Babbage, if you put into the machine wrong figures, will the right answers come out?" ... I am not able rightly to apprehend the kind of confusion of ideas that could provoke such a question.
    —Charles Babbage, Passages from the Life of a Philosopher

    How to post a question to get the most help http://www.sqlservercentral.com/articles/Best+Practices/61537

  • BWFC (4/30/2014)


    Koen Verbeeck (4/30/2014)


    BWFC (4/30/2014)


    Koen Verbeeck (4/30/2014)


    BWFC (4/30/2014)


    Koen, that really gives the answer away, you don't even need Google :ermm:

    Your point being?

    Normally you only see this thread after you answered the question.

    There's a Discuss link under the question on the homepage. It brings you straight to the discussion without having to answer the question. It may have been used in the past as a possible source of clues... Although not necessarily to the answer I hasten to add, more the interpretation of the question.

    Never noticed the discuss link, good that you mention it.

    It certainly has its uses but I'm always careful what I post because unscrupulous types could use it to bypass the hours of research that I may have been through. As I said, if the meaning of the question isn't always clear it's a useful place to get hints as to what the intention may have been. To be honest I don't think a lot of people know it's there though.

    And those unscrupulous types could get one point more! :blink: đŸ˜€

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

  • Thanks for the link Koen.

    Koen Verbeeck (4/30/2014)


    Interesting question, thanks.

    For people who like an official reference:

    ALTER TABLE (Transact-SQL)

    ALTER COLUMN

    Specifies that the named column is to be changed or altered.

    The modified column cannot be any one of the following:

    * ...

    * A computed column or used in a computed column.

    * ...

  • Knew this as I had faced this situation before đŸ™‚

    Thanks & Best Regards,
    Hany Helmy
    SQL Server Database Consultant

  • BWFC (4/30/2014)


    Koen Verbeeck (4/30/2014)


    BWFC (4/30/2014)


    Koen Verbeeck (4/30/2014)


    BWFC (4/30/2014)


    Koen, that really gives the answer away, you don't even need Google :ermm:

    Your point being?

    Normally you only see this thread after you answered the question.

    There's a Discuss link under the question on the homepage. It brings you straight to the discussion without having to answer the question. It may have been used in the past as a possible source of clues... Although not necessarily to the answer I hasten to add, more the interpretation of the question.

    Never noticed the discuss link, good that you mention it.

    It certainly has its uses but I'm always careful what I post because unscrupulous types could use it to bypass the hours of research that I may have been through. As I said, if the meaning of the question isn't always clear it's a useful place to get hints as to what the intention may have been. To be honest I don't think a lot of people know it's there though.

    Now a lot know it because of this discussion đŸ˜‰

    Thanks & Best Regards,
    Hany Helmy
    SQL Server Database Consultant

  • paul s-306273 (4/30/2014)


    Thanks for the link Koen.

    Koen Verbeeck (4/30/2014)


    Interesting question, thanks.

    For people who like an official reference:

    ALTER TABLE (Transact-SQL)

    ALTER COLUMN

    Specifies that the named column is to be changed or altered.

    The modified column cannot be any one of the following:

    * ...

    * A computed column or used in a computed column.

    * ...

    +1, no reference in the answer!

    Thanks & Best Regards,
    Hany Helmy
    SQL Server Database Consultant

Viewing 15 posts - 1 through 15 (of 31 total)

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