Re: simple ALTER TABLE question
From: Gail Erickson [MS] (gaile_at_online.microsoft.com)
Date: 01/25/05
- Next message: Lee Tudor: "Re: is there any way to select items from list.items where items not in (select bans from banlist) but such that list.item is compared using the like operator e.g. like '%foo%' ?"
- Previous message: --CELKO--: "Re: Using Cursors"
- In reply to: AFN: "simple ALTER TABLE question"
- Next in thread: AFN: "Re: simple ALTER TABLE question"
- Reply: AFN: "Re: simple ALTER TABLE question"
- Messages sorted by: [ date ] [ thread ]
Date: Mon, 24 Jan 2005 16:14:10 -0800
>I absolutely hate all the garbage syntax documentation that doesn't contain
> examples. All the syntax docs show brackets and braces and I don't know
> which ones I leave out when entering text for real.
I agree the ALTER TABLE syntax can be particularly daunting with its many
options. You might find the topic "Transact-SQL Syntax Conventions"
helpful in figuring out what all the brackets and braces mean. Also, you'll
be happy to hear that we're working hard to add more examples to the syntax
topics in SQL Server 2005. For example in the ALTER TABLE topic in SQL
Server 2000, there are 8 examples. In that same topic in SQL Server 2005,
there are 15.
-- Gail Erickson [MS] SQL Server Documentation Team This posting is provided "AS IS" with no warranties, and confers no rights "AFN" <newsDELETETHECAPSgroupaccount@DELETETHISyahoo.com> wrote in message news:KVdJd.9$e11.0@twister.socal.rr.com... >I absolutely hate all the garbage syntax documentation that doesn't contain > examples. All the syntax docs show brackets and braces and I don't know > which ones I leave out when entering text for real. > > I just want to add a bit column to an existing table, setting it to 0 by > default on existing/new records. > > I tried: > > ALTER TABLE ADD COLUMN MyNewField BIT SET DEFAULT 0 > > but that doesn't work. I tried multiple variations with no luck. I know > this is simple but it would be easier if the docs said when to uses > brackets/braces, versus not, and if they gave lots of examples. > >
- Next message: Lee Tudor: "Re: is there any way to select items from list.items where items not in (select bans from banlist) but such that list.item is compared using the like operator e.g. like '%foo%' ?"
- Previous message: --CELKO--: "Re: Using Cursors"
- In reply to: AFN: "simple ALTER TABLE question"
- Next in thread: AFN: "Re: simple ALTER TABLE question"
- Reply: AFN: "Re: simple ALTER TABLE question"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
