Alter Column

  • shanjan.sapra

    Mr or Mrs. 500

    Points: 555

    Comments posted to this topic are about the item Alter Column

  • free_mascot

    One Orange Chip

    Points: 27168

    Good one, thanks.

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

  • Koen Verbeeck

    SSC Guru

    Points: 258924

    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

  • rhythmk

    SSCertifiable

    Points: 7162

    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
    🙂

  • domenico.delbrocco

    Mr or Mrs. 500

    Points: 586

    Nice question

    I need to read again the rules about the ALTER TABLE

  • Neil Burton

    SSC-Insane

    Points: 21920

    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 [/url]

  • Koen Verbeeck

    SSC Guru

    Points: 258924

    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

  • Neil Burton

    SSC-Insane

    Points: 21920

    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 [/url]

  • Koen Verbeeck

    SSC Guru

    Points: 258924

    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

  • Neil Burton

    SSC-Insane

    Points: 21920

    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 [/url]

  • Koen Verbeeck

    SSC Guru

    Points: 258924

    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

  • paul s-306273

    SSChampion

    Points: 10549

    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.

    * ...

  • Hany Helmy

    SSChampion

    Points: 13321

    Knew this as I had faced this situation before 🙂

  • Hany Helmy

    SSChampion

    Points: 13321

    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 😉

  • Hany Helmy

    SSChampion

    Points: 13321

    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!

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

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