Adding a column to view

Question

Post reply

Adding a column to view

Viewing 4 posts - 16 through 19 (of 19 total)

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

Gail Shaw SSC Guru Points: 1004514 More actions · Answer 1

You do know that query analyser has the capability to do a syntax check for you, without running the code?

Msg 102, Level 15, State 1, Line 2

Incorrect syntax near '('.

Msg 102, Level 15, State 1, Line 5

Incorrect syntax near 'MODIFY'.

You're not going to learn by trial and error. Look at the books online entry. There's even an example right there in the page that I gave you the link to that alters a table and adds a column with a default value!

Example F.

Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

rahulsony111 Hall of Fame Points: 3865 More actions · Answer 2

rahulsony111

Hall of Fame

Points: 3865

December 8, 2009 at 2:55 pm

#1089544

sure man this time i will come with correct code

Gail Shaw SSC Guru Points: 1004514 More actions · Answer 3

One thing, looking at the other thread you posted, is this a SQL Server 2000 database server? Or are you working with a different database engine, like Oracle?

Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

Alvin Ramard SSC-Forever Points: 41190 More actions · Answer 4

GilaMonster (12/8/2009)
One thing, looking at the other thread you posted, is this a SQL Server 2000 database server? Or are you working with a different database engine, like Oracle?

Gail, looks like you scared the OP away. 😉

Alvin Ramard
Memphis PASS Chapter[/url]

All my SSC forum answers come with a money back guarantee. If you didn't like the answer then I'll gladly refund what you paid for it.

For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]