so i bought sam teach urself sql "in ten minutes"
unfortunately it covers the alter tag but not its use to modify columns >:(
I'm a bit stuck with this one atm
------------
1> alter table news modify ( dateadd varchar(80))
2> go
Msg 170, Level 15, State 1, Server NEIL, Line 1
Line 1: Incorrect syntax near '('.
1
what exactly am I doing wrong?Check out the previous Transact-SQL link, or download the Books Online. :-)
The syntax should be something like this:
ALTER TABLE news ALTER COLUMN dateadd varchar(80)
Terri|||erm where can i find the books online (a direct link would be great - I'm so tired i keep just going round in circles and missing everything)|||lol
i'm being completely lame today after all that it wouldn't let me change the attribute of dateadd (cos its a time stamp) and had to remove and add any way
8P|||This is a large download, but no one should be without Microsoft's freeBooks Online.
Terri|||Books Online is in my quick launch bar, and a shortcut from the desktop...
Not many things get to have that luxury on my machine, but Books Online as well as MSDN happen to be better to me than google.|||how do you actually use the bol?
Is there a help module which acts as a top/contents page?
