Alter Column

Question

Alter Column

shanjan.sapra

Mr or Mrs. 500

Points: 555
More actions
April 29, 2014 at 11:49 pm

#307097

Comments posted to this topic are about the item Alter Column

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

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

free_mascot One Orange Chip Points: 27169 More actions · Answer 1

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: 259115 More actions · Answer 2

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: 7271 More actions · Answer 3

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 SSChasing Mays Points: 617 More actions · Answer 4

Nice question

I need to read again the rules about the ALTER TABLE

Neil Burton SSC-Insane Points: 23008 More actions · Answer 5

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

Koen Verbeeck SSC Guru Points: 259115 More actions · Answer 6

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: 23008 More actions · Answer 7

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

Koen Verbeeck SSC Guru Points: 259115 More actions · Answer 8

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: 23008 More actions · Answer 9

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

Koen Verbeeck SSC Guru Points: 259115 More actions · Answer 10

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: 10730 More actions · Answer 11

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: 13921 More actions · Answer 12

Knew this as I had faced this situation before 🙂

Thanks & Best Regards,
Hany Helmy
SQL Server Database Consultant

Hany Helmy SSChampion Points: 13921 More actions · Answer 13

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

Hany Helmy SSChampion Points: 13921 More actions · Answer 14

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